Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Looking to figure out a solution with multiple If statements. Scenario below.
Example, I have a column called ProjectScope / LaborBilling "Labor billing reflects the total revenue associated with a project"
Project Scope
New
Upgrade
Custom Dev
Looking to create a measure that IF Project Scope = 'New' then take LaborTotal Column/125, IF Project Scope = 'Upgrade' then take LaborTotal Column / 100, IF Project Scope = ' Custom Dev' then take LaborTotal Column/200.
ProjectScope and LaborBilling are not calculated columns.
Using data grid to display project name and new measure is the end result.
Any thoughts are appreciated.
Solved! Go to Solution.
Hi @dskeane
Have you considered creating a calculated column that incorporates that logic?
And then you can create simple measures over the new column.
Hi @dskeane
Have you considered creating a calculated column that incorporates that logic?
And then you can create simple measures over the new column.
This will get me on the right track, however I am running into an issue with the error in the screen shot. T&M is coming from another colum not related to my formula?
LaborBilling Data Type:Text Format:Text
I think this is the problem. You have text in that column and you are trying to use a mathmatic operator with a text value.
You can extend your IF statement to only look for numeric values, or filter out the text from this column and convert the column to numeric.
Nevermind, oversite on my end. I should have been using another colum called calculatedlaborttl this has a decimal data type.
I am smooth sailing from this point on, thanks for the suggestion!