Forum Discussion
Previous date's value
How do I create a measure that calculates and retrives the average of previous date values whenever the new data's corresponding values are added to the underlying dataset of the report? I wanna use ...
Hi,
PBI file attached.
Hope this helps.
Mr. Ashish_Mathur Thank you for your reply...
I've tested your solution (your powerbi report -Last date.PBIX) to make sure that it's working as expected.
it seems that this measure is working fine if the added date is in the same year but if the year is changed then, it won't show the previous date "which is in the last yeas". I mean if the last prodction date is "for example" 1/1/2025, your report will show the prodction of any site in max month 1/1/2025 but the prodction of any site for the previous month which is gonna be 1/3/2024 won't be shown.?
You are welcome. Share the download link of the PBI file with the data that you have shown in the screenshot.