tejapowerbi
New Member
- Joined
- Nov 30, 2018
- Messages
- 19
[FONT="]How to use =SUMIFS for below table in power bi.[/FONT]
[FONT="]=SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID)[/FONT]
[FONT="] [/FONT]
<tbody style="box-sizing: inherit;">
</tbody>
[FONT="]=SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID)[/FONT]
[FONT="] [/FONT]
Prior Months | Region | Sale Region | UI | PID |
Europe | Europe | ABC | ABC | |
12 | Europe | Europe | XYZ | XYZ |
12 | Europe | Europe | OPQ | OPQ |
2.5 | Americas | Americas | LKM | LKM |
2.5 | Americas | Americas | PKR | PKR |
2.5 | Americas | Americas | JKL | JKL |
2.5 | Americas | Americas | GUJ | GUJ |
2.5 | Americas | Americas | RAJ | RAJ |
<tbody style="box-sizing: inherit;">
</tbody>