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.
Hello
I have a question about how do I put two different formula in one column? And also there are some cells have to be empty in same column in a Table or Matrix visualization. Example please see below.
Not sure what statement should be use. If anybody can help about this question will be appreciated!
Number %Net
T/O Gross Total 1 (Has to be empty)
Sales Deductions 3 =Sales Deductions/T/O gross total
Turnover net total 4 (Has to be empty)
Var. Costs 5 = Var.Costs/Turnover net total
Other Cost 6 = Other cost/ Turnover net total
You can use SWITCH function.
Measure =
SWITCH([Number],
1,blank(),
3,Sales Deductions/T/O gross total,
4,blank(),
5,Var.Costs/Turnover net total,
6,Other cost/ Turnover net total
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hello
Thank you very much! I tried but I think my data prob is that I have Jan-Sep data, and the number will change depending on what month I choose. So the "Number" column is already a measurment. I am not sure what value should I put in this SWITCH function when my Number going to change by filtering month?
Thank you so much!
Can you share a sample of your data or PBIX file? (after removing sensitive data)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |