Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
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.
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.
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
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?
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.
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.
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?
Not Working
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |