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 Paid1122.770312.1276.9701283.85 1144.81 001026 1811.330 1147.197.094340.81 2,596 0

gauravnarchal If a new column: New Column = IF([Cash Paid] = "NA", 0, [Cash Paid])

Post Prodigy

4 years ago

Solved

If Statement

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

Greg_Deckler
4 years ago
gauravnarchal If a new column:

New Column = IF([Cash Paid] = "NA", 0, [Cash Paid])
Anonymous
4 years ago
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.