Previous Month vs 2 month ago

[filippoalicicco]

Hi experts!

I have a problem with a dax: I would like to calculate the difference % between "settembre 2018" and "agosto 2018"

I try with this measure but it doesn't work:

SEPTEMBER MONTH = TOTALMTD(SUM([Table1]>=DATE(YEAR(TODAY());MONTH(TODAY());1) && Mese[Date]< DATE(YEAR(TODAY());MONTH(TODAY())+1;1))

AUGUST MONTH = TOTALMTD(SUM([Table1]);Mese[Date] >= DATE(YEAR(TODAY());MONTH(TODAY());-1)&&Mese[Date]<DATE(YEAR(TODAY());MONTH(TODAY());1))

Can you help me? 

thx

Fil

[Greg_Deckler · Accepted solution]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[filippoalicicco · Accepted solution]

Hi!

I resolved with this mesaure:

CALCULATE([Table1];PARALLELPERIOD(Mese[Date];-1;MONTH))

[v-danhe-msft]

Hi @filippoalicicco,

Could you please share some sample file if possible? You could upload your report to your OneDrive or Dropbox and send the link to me.

Regards,

Daniel He

[filippoalicicco · Accepted solution]

Hi!

I resolved with this mesaure:

CALCULATE([Table1];PARALLELPERIOD(Mese[Date];-1;MONTH))

[v-danhe-msft · Accepted solution]

Hi @filippoalicicco,

It's pleasant that your problem has been solved, could you please mark the reply as Answered?

Regards,

Daniel He

[Greg_Deckler · Accepted solution]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[filippoalicicco]

Thank you for your example but i don't be able to works it

😞