Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago
Solved

My previous month Exp return null amount

Hi All

 

I have below YTD expression working fine :-

_YTD EXP = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_EXP] = "EXP")

 

Since i need to get Previous month amount , i modify above expression to below :-

EXP PREVIOUS Sales = CALCULATE(GL[AMOUNT],previousmonth('Date'[Date]),GL[1_EXP] = "EXP")

 

But i get null display.

https://www.dropbox.com/s/x4kh3k5ljvubai7/PBT_V2021_382%20TI_SI_GL%20Previous%20month%20EXP%20return%20null.pbix?dl=0

Above link is my PBI file

 

Paul

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    admin11 , no date is selected so previous month is not coming. I added month and year filter and able to get that.

     

    Without a date filter try like

     

    EXP PREVIOUS Sales = CALCULATE(GL[AMOUNT],eomonth('Date'[Date],0) = eomonth(today(),-1),GL[1_EXP] = "EXP")

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    admin11 , no date is selected so previous month is not coming. I added month and year filter and able to get that.

     

    Without a date filter try like

     

    EXP PREVIOUS Sales = CALCULATE(GL[AMOUNT],eomonth('Date'[Date],0) = eomonth(today(),-1),GL[1_EXP] = "EXP")