Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Year on Year Comparison with a Line Chart

Hello! What I want to do is to plot one year's worth of data vs another year on a line chart.    My data is set up as a Value per Month. So in the Month column you have dates, assigned to the first...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous 

Thanks for reaching out to us.

My suggestion is that you can create two separate date tables and put them into different slicers. Alternatively, you can just create a date table and then use measure to get the year before the selected date, the function can use edate() and so on, EDATE function (DAX) - DAX | Microsoft Learn

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.