topic DAX Query in DAX Commands and Tips

DAX Query

GShal — Tue, 14 May 2024 17:25:15 GMT

Hi,

I am trying to create ifese function but is is not giving me any column name in logical condition

eXAMPLE: I am creating a new column with condition IF(-- = "Mumbai", true,false)

So where -- is present no column name is coming here it giving me an error in the formula

Please help

Syk — Tue, 14 May 2024 18:54:34 GMT

If this is for a measure, you have to use an aggregation function. Trying something like

some_measure = IF ( MAX('table'[column]) = "Mumbai", 1, 0)

Anonymous — Mon, 20 May 2024 06:48:30 GMT

Thanks Syk for the quick reply. I have some other thoughts to add:

If you want to create a calculated column, first select a table and then click New Column.

Enter the following formula.

Column = IF([Column1]="Mumbai","true","false")

Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.