Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.