topic Need Help in changing the format of DAX formula in DAX Commands and Tips

Need Help in changing the format of DAX formula

Anonymous — Sat, 07 May 2022 19:22:20 GMT

Thanks for helping in the below mentioned question.

Solved: Re: Need Help with DAX Command - Microsoft Power BI Community

below is the formula which is working fine .
CYCQCW-Win Rev =
VAR CurrentFCST = MAX ( 'Trend'[FCST] )
VAR CurrentWeek = MAX ( 'Trend'[WEEK_NUM] )
VAR CurrentStage = MAX ( 'Trend'[SS_No])
VAR CurrentValue = MAX ( 'Trend'[REV$M] )
VAR MaxWeek = CALCULATE ( MAX ( 'Trend'[WEEK_NUM] ), ALLEXCEPT ( 'Trend', 'Trend'[FCST] ) )
RETURN
IF (
CurrentFCST = "CQ" && CurrentWeek = MaxWeek && CurrentStage IN { "07", "08" },
CurrentValue,
0
);

After creating a column with above formula i converted it into a card and then i wanted to add $ and M and hence tried changing the format but it is not allowing me to chnage the format from text to currency.

Can anyone please help me !!

Thanks & Regrards
Shiv

Re: Need Help in changing the format of DAX formula

tamerj1 — Sat, 07 May 2022 19:44:16 GMT

Anonymous

Check the data type in power query should be decimal

Re: Need Help in changing the format of DAX formula

v-yanjiang-msft — Thu, 12 May 2022 07:33:31 GMT

Hi Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj