Forum Discussion

Dshami's avatar
Dshami
Frequent Visitor
3 years ago

Total of Measure showing wrong value

I am having a calculated column with conditional IF statement. Using which I am trying to create the current and previous year total sales.. all the columns and measures have decimal value as datatyp...
Need Help
Jayee's avatar
Jayee
Icon for Responsive Resident rankResponsive Resident
3 years ago

Hi Dshami ,

 

Try below measure

 

Measure = Sumx(summarize(tablename,[Date],"X",[Current Year]),[X])

 

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!