Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello everyone,
I need to create a PowerBI visualization in which I should be able to see the values of different measures for the current day and for the same day of the week before and have another column that shows the day-over-day change percentage.
My table should look something like this:
09-08-23 | 02-08-23 | DoD | |
Measure 1 | 0.5 | 0.9 | 80% |
Measure 2 | 11128 | 11128 | 0% |
Measure 3 | 500 | 1,000 | 100% |
Where DoD = (Current Date Value / Same day of last Week Value) -1
Currently I'm not being able to put the date columns and the DoD column side by side.
Is this possible?
Thanks in advance
@Anonymous , You can measure like
This Day = SUM(Sales[Sales Amount])
7 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAy))
diff =[This Day] - [Last Day]
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |