Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community,
Is there a way I can capture and show historic data in some point of time.
My data refreshes daily and projects only the latest data.
For instance:
A ticket is created on 15 Feb 2021, on 18 Feb 2021 it is pending and on 20 Feb 2021 its is closed.
However the data now shows as closed on 20 Feb 2021. I want to see the status from creation till closed.
Ticket | Date | Status |
A | 15 Feb 2021 | Closed |
B | 3 March 2020 | Closed |
Would really help me as I have been trying since last one week 😞
Thank you in advance
Solved! Go to Solution.
@schoden , Try that Dax append way first, Then you need to check max status before that date.
calculate(lastnonblankvalue(Table[Date], Max(Table[Status])), filter(all(Table), Table[ticket] = max(Table[tickte]) && Table[Date] <= max(Table[Date]) ))
Hi All ,
I am grarteful for replies/solution given. However one solution worked for me or atleast got me to the closest goal is Incremental refresh using PowerBI pro and Dataflows - Exceed blog by
https://www.youtube.com/watch?v=aAzSZbrICxE
Thought I will share in the forum 😃
Hi@schoden,
It's pleasant if your problem has been solved, could you please mark the reply as Answered? that way, other community members will easily find the solution when they get the same issue.
Hope it helps.
Best Regards,
Caitlyn Yan
@schoden , I do not see any data for creation.
1. Data is getting overwritten and you do not have that. Refer DAX append to snapshot the data first
2. You have not shown an example of data showing an open line. PLease share data in that case
Check DAX append
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Yes the data gets overwritten in the status field.
Status have value (bascially all those values projects at a point of time )
1. Created
2. Pending
3.Closed
4. Rejected
@schoden , Try that Dax append way first, Then you need to check max status before that date.
calculate(lastnonblankvalue(Table[Date], Max(Table[Status])), filter(all(Table), Table[ticket] = max(Table[tickte]) && Table[Date] <= max(Table[Date]) ))
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |