DAX Help Year Over Year

[Anonymous]

I would like to display Year Over Year comparision in Cluster column chart for last five year based on single Date selection through slicer. How do we write a DAX for this?

[v-yiruan-msft]

Hi @Anonymous ,

You can refer the content in the following links to get it. If they are not applicable for your scenario, please provide some sample data(exclude sensitive data) and your expected result. Thank you.

I want to display last 5 years sales when i select one year

Display Last N Months & Selected Month using Single Date Dimension in Power BI

Best Regards