Filter Value Changing from Desktop to Power BI Service

[rosie1931]

Hello,

I have a table that displays activities due today.  In the data table, I have a column that marks today with a '1' and the filter works fine in Power BI Desktop.

When I uploaded the report to Power BI Service, the row that has the '1' gets turned to a '0.'  I went into the semantic model online and changed the value, refreshed it, but will not show up in the filtered table.   

I have a gateway connected to the data, but do not know why the value would change from one format to the other.

Does anyone have an idea why this would happen?

[rosie1931]

Hello @Sahir_Maharaj ,
I tried the DAX and keep getting the errors listed above.  Do you have any ideas how I can adjust code?

[Sahir_Maharaj]

Hello @rosie1931,

Can you please try this DAX:

Today Flag = 
VAR TodayUTC = TODAY()
VAR LocalTimeOffset = -5 // Example: EST is UTC-5. Adjust this based on your time zone.
VAR AdjustedToday = DATEADD(TodayUTC, LocalTimeOffset, HOUR)
RETURN
IF (
    YourTable[YourDateColumn] = AdjustedToday,
    1,
    0
)

Hope this helps.

[rosie1931]

Hi Sahir,

Thank you for getting back to me.  I entered in the DAX formula and there was a 'Parameter is not the correct type' error message for TodayUTC in the AdjustedToday variable.  Is that because it is only referencing on day and not a range?

[rosie1931]

Another error I'm receiving says that the last argument of the the DateAdd function has to be Day, Month, Quarter, Year.  Will the function still work with Hour?