Re: getting previous month using time intelligence

Anonymous · ‎10-02-2019

hello. below is the DAX formula that i am using to try to get the previous month's data but I keep getting a blank. can someone please help?

= CALCULATE( sum('tbl_Combined_InvoiceData'[Charges]), filter('Date2','Date2'[Period].[Date] = date(year(today()),Month(Today())-1, day(today()))))

az38 · ‎10-02-2019

Hi @Anonymous

try

= CALCULATE( sum('tbl_Combined_InvoiceData'[Charges]), PREVIOUSMONTH('Date2'[Period]))

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Anonymous · ‎10-04-2019

thanks. i still get a blank value 😞

getting previous month using time intelligence