Labbel with previous year data

[AgustinLopez]

Hello, I'm new in Power Bi and I have some trouble making some DAX if you can help me be appreciate.

I have the following data.

And I'm showing it in a Bar Chart

Also, I have some labels that when you click in one bar show some data of that bar, but also I need to show in a label the shipment YTD of the previous year. I have a Year Column

If I click the bar of the season 2019-2020 March I need to see the value Shipment YTD of 2018-2019 March

Can you help me with the DAX
Thanks!

[Pragati11]

Hi @AgustinLopez ,

I wrote a blog sometime back in which I have shown previour year sales calculation.
When you click on a bar with current year sales, the card visual on the top shows the previous year sales.

Link to the blog:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Labbel-with-previous-year-data/m-p/1543956

I think this will ive you an idea for your requirement.

Thanks,

Pragati