Transform SQL to DAX

[user2023]

I'm new to Powerbi, and I'm having trouble converting this SQL code to DAX
measure: perc_ating {
label: "∆ % Monthly Goal"
type: number
sql: case when
${perc_ating_aux} >= 0 then ${perc_ating_aux}
else 100 end
;;
value_format: "#.0\%"
}.
Can anybody help me

[Greg_Deckler]

@user2023 This would be easier with sample data and expected output but maybe try:

perc_ating measure = IF( [perc_ating_aux] >= 0, [perc_ating_aux], 100)

[user2023]

@Greg_Deckler But how would I put the value format "#.0\%" for it to come within this condition?

[Greg_Deckler]

@user2023 Either @R1k91 's method or you can use a Custom Format String. Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn. You could use FORMAT but that will turn it into text.

[R1k91]

couldn't you simply use format pane for that measure?