Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

IF Statement - Power BI Desktop

Hi everyone,      I have a simple question and wantes some assitance. I have two columns (Reference Status and Date) in my dataset and wanted to create a simply IF statement. I want the IF stateme...
  • Sean's avatar
    Sean
    10 years ago

    Anonymous if you want to do this in Table View (after you've imported your Data) you use DAX like so

     

    DAX => New Column = IF ( [Reference Status]="No", [Date], BLANK() )

     

    if you want to do this during import in the Query Editor (just follow the picture)

    Give the Column a Name and the conditions - the Query Editor will genetrate the column in M which is

    M => if [Reference Status] = "No" then [Date] else ""

     

Sean's avatar
Sean
Community Champion
10 years ago

Anonymous if you want to do this in Table View (after you've imported your Data) you use DAX like so

 

DAX => New Column = IF ( [Reference Status]="No", [Date], BLANK() )

 

if you want to do this during import in the Query Editor (just follow the picture)

Give the Column a Name and the conditions - the Query Editor will genetrate the column in M which is

M => if [Reference Status] = "No" then [Date] else ""

 

msalam's avatar
msalam
Frequent Visitor
9 years ago

I'm receiving this error in my DAX query on calculated column as follows:

 

Column = IF(Reading[ServiceId]=1, Reading[Value] , "On")

 

ERROR:

Function 'IF' is not allowed as part of calculated column DAX expressions on DirectQuery models

 

Any Idea why i'm receiving that error?