Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'd like to record the output of a measure and get the historical data of said measure, to use for visualization. For example, I calculate the avergage turnover per day with a measure. I'd like to have this output be stored in a table, with the date of today.
Does anyone have any idea how I can achieve this? Thanks in advance!
Hi, @Sohan
Please correct me if I wrongly understand your question.
The below shows Date-table and Sales-table that are not connected.
By writing a measure shown in the picture, the historical data that is before the selected date can be shown.
I think, this can be used as a stored data inside your other measure by using it together with VAR.
If it is OK with you, please kindly share your sample pbix file, then I can try to come up with more accurate measures.
thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |