Wednesday, July 25, 2012 12:26 PM
I have a DAX formula which Is not giving me the results required.
Would appreciate your assistance.
(If a value is between the below different criteria values...show it otherwise return a blank).
I'm sure this can be incorporated into 1 DAX formula entirely.
Name of table= [QUERY]
Column data extraction = [VOLUMES]
My formulas in 3 columns which I will call later with a slicer:
Thanking you in advance.
Wednesday, July 25, 2012 6:57 PMYou need to add a "bucket" table to your data model.
Wednesday, July 25, 2012 7:08 PM
Hello David, Would you provide me with a example on how to predefined this data table? This is the first time I'm face with this issue.
I was thinking there was something wrong with my formula.
Would this formula work after the bucket is linked?
Thursday, July 26, 2012 8:43 AMWhy not use the SWITCH syntax?
Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog
Tuesday, July 31, 2012 12:17 AM
I'd create a table "MyBuckets" like this
LowVolume HighVolume Value 0 199 MV 200 1499 PT 1500 1501 VP
Then you can use DAX as below:
=calculate(values(MyBuckets[Value], filter(MyBuckets, query[volumes])>=MyBuckets[LowVolume] && query[volumes]<MyBuckets[HighVolume])
-- This posting is provided "AS IS" with no warranties, and confers no rights
- Marked As Answer by AntoMtl Tuesday, July 31, 2012 12:44 PM
Tuesday, July 31, 2012 12:44 PMThank you...will give this a try.