Forum Discussion

sammy02hk's avatar
sammy02hk
Icon for Helper I rankHelper I
3 years ago
Solved

Modifying DAX Code for retrieve full data

Hi there, Below is the sum of Sales with  LLM last last month, LM Last Month, TM This Month Hope my result like: 1st approach: Right now i can retrieve the result by selecting Billin...
  • RichardOfSydney's avatar
    RichardOfSydney
    3 years ago

    mSale:=SUM(Sales[sale])

    mSalesLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-1,MONTH))

    mSalesLLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-2,MONTH))

     

RichardOfSydney's avatar
RichardOfSydney
Regular Visitor
3 years ago

mSale:=SUM(Sales[sale])

mSalesLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-1,MONTH))

mSalesLLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-2,MONTH))

 

sammy02hk's avatar
sammy02hk
Icon for Helper I rankHelper I
3 years ago

Hi RichardOfSydney ,

Thank you for your help.
But the LLM get the same result with This month.

Cheers,

Sammy Chu

  • RichardOfSydney's avatar
    RichardOfSydney
    Regular Visitor
    3 years ago

    Dont use the var, they are 3 distinct measures.

     

  • sammy02hk's avatar
    sammy02hk
    Icon for Helper I rankHelper I
    3 years ago

    RichardOfSydney 
    Its work, when the sum put back. Thank you very much