Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Best Way to Summarize Data

Hello all,   I need to summarize the data in the screen shot, it needs to show the amount of PAID_HOURS and MONETARY_AMOUNT grouped by month by FinHrRollupName.   Example:   FinHrRollupName ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

We can create a measure like that to work on it.

 

Measure =
VAR name =
    MAX ( table[FinHrRollupName] )
RETURN
    CALCULATE (
        SUM ( table[value] ),
        FILTER ( ALLSELECTED ( table ), table[FinHrRollupName] = name )
    )