I formatted a column in my dataset as currency (Sales values) and I use it in the measure below:
RunningNettoWeek = CALCULATE(SUM(Sales[NETTOPREMIE]);FILTER(ALL(Sales[Week]);Sales[Week] <= MAX(Sales[Week])))
But whenever I run the measure, the values lose their formatting. I tried wrapping it with CALCULATE() function in FORMAT(), but the values ended up not showing in my charts. How can I retain the formatting in this scenario?