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!
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
