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 🙂
I am currently working with some data, which is aggregated in that sense, that it is a snapshot that is taken each day which is the total.
I.e. I have the following table which does only include business days - I am using a datetable for that named DimDate
Date | Group | Market Value |
08/03/2023 | Net Asset Value | 100 |
09/03/2023 | Net Asset Value | 102 |
10/03/2023 | Net Asset Value | 103 |
13/03/2023 | Net Asset Value | 101 |
I have tried using the built-in functionalities like TotalYTD etc. but they sums it all up providing me with a very large number.
Based on the above table I would like the YTD to be 101 - 100 = 1
Does anyone know how to solve this? Please let me know if anything else is required from my side to sort this.
Best Regards,
Solle
Solved! Go to Solution.
@Solle See this: Better Year to Date Total - Microsoft Power BI Community
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
@Solle See this: Better Year to Date Total - Microsoft Power BI Community
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Hi @Greg_Deckler
Thank you for your input, the video and in particular your very fullfilled work on the time intelligence functions helped me to come up with a solution as per below:
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |