DAX Query

[GShal]

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 · Accepted solution]

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 · Accepted solution]

Hi @GShal ,

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. 

[Syk · Accepted solution]

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)