Forum Discussion
parry2k
Super User
Super UserHow to group data?
I have data as listed below and would like to put a pie graph showing data in two group amt pending for days passed less than equal to 5 days amt pending for days passed more than 5 days th...
Protip: Instead of using multiple IF-clauses, you should use the switch()-function. It is pretty good explained here:
http://www.powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/
vasim07
Helper I
Helper IUntested but should work.
From Ribbon - New Measure.
lessthan5days = CALCULATE(SUM(TABLENAME[PRINCIPLE AMOUNT PENDING]),TABLENAME[DAYS PASSED] <= 5) morethan5days = CALCULATE(SUM(TABLENAME[PRINCIPLE AMOUNT PENDING]),TABLENAME[DAYS PASSED] > 5)
Now, use both this metrics to plot a pie chart.
Regards,
Vasim Shaikh
- parry2k
I used the if condition for now.
Thanks everyone for the solution.
BjoernContinued Contributor
Protip: Instead of using multiple IF-clauses, you should use the switch()-function. It is pretty good explained here:
http://www.powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/
