DAX to Filter dates using specific Category and then apply if condition

[Anonymous]

Hi, 

I need help, I am not sure if I am even trying which make sense or not. 

I have the above table. I want to filter "Task 2" from the "Task Name" column and then check if "Finish" is > "BL Finish" then print "Behind" else  "Target" . 

Any help would be appreciated. 

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

Based on  your description, the issue would not appear when you create a new pbix file?

And it works fine on my side as well. so this seems like a transient issue should go away. 

Make sure your PBI is always the latest version.

And actually when you create a calculated column,prefix of table name is not necessary, so you could simply use the following formula:

Column = IF([Task Name]="Task2" ,IF( [Finish]>[BL FInish],"Behind","Target"))

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

[mattww]

Hi @Anonymous ,

If I'm understanding your rule correctly, would a Calculated Column like this work?

TargetStatus = IF('Table'[Task Name] = "Task2",IF('Table'[Finish] > 'Table'[BL Finish],"Behind","Target"),BLANK())

The same could be achieved in Power Query, different syntax, so let me know if that's preferable

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

[Anonymous]

Not sure what's happening. I have closed the current file PBIX and opened the new PBIX. It worked. Unbelievable I spent hours using different combinations of DAX and looks like some different problem... not sure.

[mattww]

Hi @Anonymous, glad to hear you got it to work, hopefully it was just something random and temporary going on in th model

If the expression is doing what you intended, please mark the post with that formula as solution, or do let me know if there's anything else I can help with

Thanks, Matt

[Anonymous]

Thanks for the quick reply. But when I am using 'If condition' does not show the "Table Column" for e.g "'Table[Task Name]'. Intellisense only shows me measures not "Table Columns".  Any idea why?

[mattww]

Hi @Anonymous, are you sure you're adding a Calculated Column and not a Measure?

Alternatively

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

[Anonymous]

See the below image. I am using a new calculated column. But it's just showing only Calc Measure not columns under sheet2 table. I may be missing something. 

[mattww]

Hi @Anonymous , that is a bit weird, it might just be your IntelliSense playing up, have you tried just typing out Sheet2[Task Name] = "Task", does that work? Do you get any red lines under the expression?

[Anonymous]

Not Working

[mattww]

Hi @Anonymous 

I'm not too sure why it's doing that, it's working fine on my end. What's the error message?

Are you using Power BI Desktop? What's the data source?