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.
Hello all,
I have two tables one with a production value from previous 5 years and a datetable.
I would like to show a same day same month value in every year compared with cuurent day. The values are producing each hour everyday as 24 values per day.
Example:
ProductionDate Production value
01/02/2016 1232
04/05/2017 12465
31/08/2017 5757
27/11/2018 3432
15/10/2018 5766
04/05/2019 5767
01/02/2019 5322
01/02/2020 2789
Visual:
Value on current date: 01/02/2020 compared from previous years
01/02/2020 : 2789
01/02/2019 : 5322
01/02/2016 : 1232
Would be a great help if one could help how to get this?
Thank you.
Best regards,
Ravali
Solved! Go to Solution.
@Anonymous - Sure,
I have attached a PBIX if it helps. Below my sig.
@Anonymous - Sure,
I have attached a PBIX if it helps. Below my sig.
Hi @Greg_Deckler ,
Thank you for your reply. I have made a little unclear question.
I need to visualize current day value and previous years on same day. Could you please help me in this?
It would be a great help.
Thank you.
Best regards,
Ravali.
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 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |