Hi everyone,
I am new here.
I have a table which looks like this.
Can you please help me with the achieving the following results on Power BI desktop using the table above?
Thanks.
Jason
I am new here.
I have a table which looks like this.
Team | Person | Period | Cost | Revenue |
A | Tom | 1 | 100 | 200 |
A | Tom | 2 | 150 | 100 |
A | Jack | 1 | 50 | 90 |
A | Jack | 2 | 75 | 80 |
B | Sarah | 1 | 300 | 400 |
B | Sarah | 2 | 150 | 500 |
Can you please help me with the achieving the following results on Power BI desktop using the table above?
Particular | Prior Month (Period <2) | Year to date |
Cost | 450 | 825 |
Revenue | 690 | 1370 |
Thanks.
Jason