Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Offset function giving wrong results for first month in X Axis

Hi Community,    Please help me with below .    The requirement is to substract current value and previous value . I used offset and it worked as expected . However, the External filter (Date fie...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

The measure can be simplied to

Measure = calculate(Average('X'[level_percentage]),previousmonth('Monthly Calendar Table SCI'[Date]))