Forum Discussion

Prateek_121's avatar
Prateek_121
New Member
2 years ago

Need help with Previous Month Calculation

Hi Team,   I am creating a DAX measure to display the sum of previous month value. I have 1 more column in my fact table which I need to use in the same report and that column stores the value of f...
Prateek_121's avatar
Prateek_121
New Member
2 years ago

 

 the formual for new logic measure is 

var _abc =  calculate([original exposure], allselected(table[originalexposure]), parallelperiod(date, -1 month)

return if([original exposure] = blank(), blank(), [original exposure] - _abc)

 

And I have used this formula also but it does subtotals if I add other dimensions and do a multi select

var _abc =  calculate([original exposure], allselected(table), parallelperiod(date, -1 month)

return if([original exposure] = blank(), blank(), [original exposure] - _abc)

 

Unfortunately I cannot share screenshot because of sensitive data

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Prateek_121 

     

    Can you simulate some dummy data to tell your question? Ideally, it will also provide the output you expect.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Prateek_121's avatar
      Prateek_121
      New Member
      2 years ago

      added dataset in my reply post