Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |