March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 in the following way: Lets take as example idEvent 10002. We want to analyze the evolution of the Status of this idEvent after 2023. As we see in the picture attached below, this idEvent in the 2023-01-17 its Status was UNAVAILABLE then it was maintained 3 days with the same status (Due to the fact that it manteined the SAME Status, we dont save those records on those days, so to save database resources) and the 2023-01-20 turned to ONLINE status. What I need to achieve in PowerBi is being able to display in a Line Chart and a Table this data "virtually autocompleted". What I mean by "virtually autocompleted" is that I need PowerBi to understand that between those 2 dates, there are 3 days in the middle were the idEvent had the same status and the visuals have to show this. Because of performance and server capacity, I dont have the possibility to save for every day and for every idEvent every record, and I can only save the dates where there was changes applied.
How its currently displaid in PowerBI :
How I need it to be displayed: (in yellow the rows that should be added by PowerBI)
Both tables Status and date:
My new table:
And create a new column:
Proud to be a Super User!
You need a second table with all dates and you have to fill a second column with the right status information from the first table.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
26 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
40 | |
27 | |
27 | |
21 | |
19 |