Forum Discussion
Need help with Previous Month Calculation
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
https://drive.google.com/file/d/1cCHUarTpIhDZDpUm0DZ_K2qY3zusu_GQ/view?usp=sharing -- link for the dummy dataset. Chart 1 and 2 are expected outputs but you can see both scenarios are not working with any measure . Chart 5 shows what is happening with date time intelligence function when I have added the flag column in the chart.