If Statement

[gauravnarchal]

How can i write a if statement as measure with the below condition?

If Table 1 {Cash Paid = "NA" return 0 else return Cash Paid}

Table 1

Cash Paid
1122.77
0
312.12
76.97
0
1283.85
1144.81
0
0
1026
1811.33
0
1147.19
7.09
4340.81
2,596
0

[Greg_Deckler · Accepted solution]

@gauravnarchal If a new column:

New Column = IF([Cash Paid] = "NA", 0, [Cash Paid])

[Anonymous · Accepted solution]

Hi @gauravnarchal ,
If you want a measure write

Measure = IF(MAX( Table 1[Cash Paid ]) = "NA" , "0", MAX(Table 1[Cash Paid]))

As this measure will perform row-by-row operation even though if you give MAX or MIN.

Regards,

Ashfiya

--------------------------------------------------------------------------------------------------------------------------

Did I help you today? Please mark my post as a solution and hit the Kudos button.

[Greg_Deckler · Accepted solution]

@gauravnarchal If a new column:

New Column = IF([Cash Paid] = "NA", 0, [Cash Paid])