CODEWITHSUNDEEP
powerbipowerquerypowerbi-desktoppower-automate
Greg.SA
Greg.SA

Reputation: 21

Power Automate / Power BI Query Automation

I am trying to duplicate a measure from one of our company reports to view which employees haven't logged in.

In Power BI I created a filter on a visual to get the result my manager was after. Now we are looking to automate it and send a mail to all users showing the list of users who haven't logged in.

In Power BI I staff master list could not be blank, the employee has to be an active employee and lastly I created a DAX measure to see if the check-in form was filled in.

I used the below code in Power Automate and couldn't get any result, just error messages.

DailyCheckMeasure = 
    VAR CurrentDate = TODAY()
    RETURN
    IF (
        NOT(ISBLANK('LF Daily Check In Staff Master List'[Daily Check-In Names])) &&
        'LF Daily Check In Staff Master List'[ActiveEmployee] = "Yes" &&
        'DAX'[DidNotFill] = 1 &&
        'LF - Daily Check In 2025'[Date] = 'DateTable'[Date] &&
        'DateTable'[Date] = CurrentDate,
        1,
        0
    )

Hopefully someone can assist me with getting power automate to duplicate the power bi result.

Upvotes: 0

Views: 25

Answers (0)

Related Questions