Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

getting previous month using time intelligence

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'[Charge...
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

 

try

= CALCULATE( sum('tbl_Combined_InvoiceData'[Charges]), PREVIOUSMONTH('Date2'[Period]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks.  i still get a blank value :(