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 datatype. But I'm getting wrong value of sum. Please guide.
My measure is
Current year = CALCULATE (SUM(Table[Total sales], DATESBETWEEN (Calendar [Date], DATE(2022,01,01), DATE (2022,12,31)))
If i drag products in table or matrix and add this same measure it shows all correct positive value (total is 8.91M) and if I drag the same measure in card it shows me -6200 value.