Forum Discussion
Different formula in one column.
Super User
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!
- VahidDM
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!!