range of values

3 Topics

Measures to aggregate by month & range values
Hi all, My data table is something like: Im asked to get a table/histogram with a row/bar per month and the number of IDs per range of summatory of hours/month: Here is an intermediate table to help you guys understand the requirement: Is it possible to get it with just with measures/DAX and not having to create the intermediate tale in the data model?? Thanks a lot in advance!
Solved
TSGD2123
3 years ago Place DAX Commands and Tips
1.2KViews
0likes
4Comments
Measure for aggregation & range values
Hello, From a source table like: Date Id Hours 01/01/2020 A 10 02/01/2020 A 8 03/01/2020 A 9 04/01/2020 B 7 05/01/2020 B 10 02/02/2020 A 11 03/02/2020 A 4 04/02/2020 B 3 05/02/2020 C 6 15/03/2020 A 8 16/03/2020 B 3 17/03/2020 C 2 18/03/2020 C 15 I'm trying to get a table with the count of Ids per Month and Id, clasified by range of values, so I'd end up with this: Month Ids whose monthly Sum Hours < 10 Ids whose monthly Sum Hours >= 10, <20 Ids whose monthly Sum Hours >20 Jan 1 1 Feb 2 1 Mar 2 1 I'm trying to figure out the measure(s) to get this, could you guys help, please? Thanks
Solved
TSGD2123
3 years ago Place DAX Commands and Tips
1.2KViews
0likes
5Comments
Dax to lookup within range of values
hi, i have a measure that compute a Factor value. Now i need to compare this factor value to the ones in the table below to look up for over/under and adjust values. eg: if my factor value is 1.063 then over/under value is -5% and adjust value is 0.78% What is the best way to do this please? merge query or dax? at the moment im using SWITCH in dax to write each value in the table but what if my table has hundreds of values then SWITCH is not possible. thanks in advance. Regards, ChimDen
Anonymous
4 years ago Place DAX Commands and Tips
540Views
0likes
3Comments