Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How do I get PowerBI to autocomplete empty time ranges from a dataset, in a visual.

I have a table called DWH_EVENT_CHANGES with basically saves records every time that occurs idEvents Status changes (idEvent status can be: 'ONLINE' , 'ARCHIVED' or 'UNAVAILABLE').  This table works ...
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Both tables Status and date:

My new table:

newtable = SUMMARIZE('Date','Date'[Date],"laststatusdate",maxx(FILTER('Status','Status'[Date]<='Date'[Date]),'Status'[Date]))

 

And create a new column:

Column = CALCULATE(max('Status'[Status]),FILTER('Status','newtable'[laststatusdate]='Status'[Date]))