Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report where I calculate whether a sensor has been activated in the last three days or not. Until today it worked perfectly, but now I get an error message in Power BI Service (NOT in Power BI Desktop, there it works just fine).
Error message:
Couldn't load the data for this visual
The query referenced calculated column 'Sensors'[IsInactive] which does not hold any data because evaluation of one of the rows caused an error.
DAX: IF(DATEDIFF(DATE(RIGHT(FIRSTNONBLANK(LiveData[Date]; LiveData[Date]); 4); MID(FIRSTNONBLANK(LiveData[Date]; LiveData[Date]); 4; 2); LEFT(FIRSTNONBLANK(LiveData[Date]; LiveData[Date]); 2)); TODAY(); DAY) > 3; "Inactive"; "Active")
The reason for not calculating the date field directly is that it is formatted as text in the data source and query format is direct query for that table.
I use the updated version of Power BI Desktop. Any suggestions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.