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 all,
I'm trying to compare volume of requests across two years and chart in on a line graph. Eg. line graph comparing Mar16-Mar17 on one line and Mar15-Mar16 on the secondary line. Any idea how I can do this?
Thanks,
Mike
Solved! Go to Solution.
Hi @mshamsiev,
I'm trying to compare volume of requests across two years and chart in on a line graph. Eg. line graph comparing Mar16-Mar17 on one line and Mar15-Mar16 on the secondary line. Any idea how I can do this?
If I understand you correctly, you should be able to make use of SAMEPERIODLASTYEAR Function (DAX) to create a new measure to do your calculations for the same period last year, which should be easier in your scenario.
For example, if you want to compare the total sales of Mar16-Mar17 and Mar15-Mar16, then you can show both [Total Sales] and [PY Sales] as the Values for the Line Chart, and use a Slicer to filter the date to Mar16-Mar17.
Total Sales = SUM(Sales[Revenue])
LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))
Regards
Hi @mshamsiev,
I'm trying to compare volume of requests across two years and chart in on a line graph. Eg. line graph comparing Mar16-Mar17 on one line and Mar15-Mar16 on the secondary line. Any idea how I can do this?
If I understand you correctly, you should be able to make use of SAMEPERIODLASTYEAR Function (DAX) to create a new measure to do your calculations for the same period last year, which should be easier in your scenario.
For example, if you want to compare the total sales of Mar16-Mar17 and Mar15-Mar16, then you can show both [Total Sales] and [PY Sales] as the Values for the Line Chart, and use a Slicer to filter the date to Mar16-Mar17.
Total Sales = SUM(Sales[Revenue])
LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))
Regards
Bump
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |