mesasure
2 TopicsMeasures 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!Solved1.2KViews0likes4CommentsMeasure 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? ThanksSolved1.2KViews0likes5Comments