comparison month with last year same month for FY

[bicoffee]

Hi

I am looking month with last year same month comparison in the below format: 

I am having data as pe rthe below structure:

[v-stephen-msft · Accepted solution]

Hi @bicoffee ,

Unfortunately, your expected result cannot be achieved in Power BI, but I have tried my best to get close to your expectation. You can check the details through the attachment.

Measure = VAR _max=CALCULATE(SUM('Table'[SALES]),FILTER('Table',[Year]=MAX('Table'[Year])))
var _min=CALCULATE(SUM('Table'[SALES]),FILTER('Table',[Year]=MIN('Table'[Year])))
RETUrn IF(HASONEVALUE('Table'[Year]),SUM('Table'[SALES]),DIVIDE(_max-_min,_max))

Best Regards,

Stephen Tao

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