Forum Discussion
Solved
DAX Help
Hello I need some help with the following DAX Syntax. I have a Measure [total qty] and need to get some DAX to do the following: If [total qty] < 1000, Then Divide[total qty] by 1. If [total...
You can use the SWITCH function to avoid multiple IF statements - i.e
Your Measure = SWITCH(TRUE(), [total qty] < 1000, Divide([total qty], 1), [total qty] < 5000 Divide([total qty], 2), [total qty] < 50000, Divide([total qty], 4), [total qty] > 50000, Divide([total qty], 6) )
You can use the SWITCH function to avoid multiple IF statements - i.e
Your Measure = SWITCH(TRUE(),
[total qty] < 1000, Divide([total qty], 1),
[total qty] < 5000 Divide([total qty], 2),
[total qty] < 50000, Divide([total qty], 4),
[total qty] > 50000, Divide([total qty], 6)
)
Vicki, you ROCK thank you so very much, this WORKS. I have spent the last 2 days trying to get it working. THANK YOU for being part of this great community.