primasatria
New member
- Joined
- Jul 19, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
[FONT="]Hi Folks,[/FONT]
[FONT="]I am newbie in Microsoft Power Bi.[/FONT]
[FONT="]I have a data in Excel, I have only 3 columns.[/FONT]
[FONT="]1st columns (A): plan date (date)[/FONT]
[FONT="]2nd column (B): actual date (date)[/FONT]
[FONT="]3rd column (C): System number (string)[/FONT]
[FONT="]Within April 2021, we have a plan to finish 11 system numbers[/FONT]
[FONT="]And within April 2021, we achieve 30 system numbers, some is part of the plan in May 2021, June 2021, August 2021 (ahead), as below:[/FONT]
[FONT="]April 2021: finish 10 system numbers, finished in April 2021[/FONT]
[FONT="]May 2021: finish 7 system numbers, finished in April 2021[/FONT]
[FONT="]June 2021: finish 9 system numbers, finished in April 2021[/FONT]
[FONT="]August 2021: finish 4 system numbers, finished in April 2021[/FONT]
[FONT="]When I to insert a pivot table in Excel, the result of April 2021 is Plan = 11 and Actual = 10[/FONT]
[FONT="]What we want of the result of April 2021 is Plan = 11 and Actual = 30[/FONT]
[FONT="]Is is possible to do it in PivotTable or Power Bi? if I used Countif function, I could get as what I expected. But not in PivotTable or Power Bi[/FONT]
[FONT="]I really appreciate it if someone could help me.[/FONT]
[FONT="]Thank you[/FONT]
[FONT="]prima - Indonesia[/FONT]
[FONT="]I am newbie in Microsoft Power Bi.[/FONT]
[FONT="]I have a data in Excel, I have only 3 columns.[/FONT]
[FONT="]1st columns (A): plan date (date)[/FONT]
[FONT="]2nd column (B): actual date (date)[/FONT]
[FONT="]3rd column (C): System number (string)[/FONT]
[FONT="]Within April 2021, we have a plan to finish 11 system numbers[/FONT]
[FONT="]And within April 2021, we achieve 30 system numbers, some is part of the plan in May 2021, June 2021, August 2021 (ahead), as below:[/FONT]
[FONT="]April 2021: finish 10 system numbers, finished in April 2021[/FONT]
[FONT="]May 2021: finish 7 system numbers, finished in April 2021[/FONT]
[FONT="]June 2021: finish 9 system numbers, finished in April 2021[/FONT]
[FONT="]August 2021: finish 4 system numbers, finished in April 2021[/FONT]
[FONT="]When I to insert a pivot table in Excel, the result of April 2021 is Plan = 11 and Actual = 10[/FONT]
[FONT="]What we want of the result of April 2021 is Plan = 11 and Actual = 30[/FONT]
[FONT="]Is is possible to do it in PivotTable or Power Bi? if I used Countif function, I could get as what I expected. But not in PivotTable or Power Bi[/FONT]
[FONT="]I really appreciate it if someone could help me.[/FONT]
[FONT="]Thank you[/FONT]
[FONT="]prima - Indonesia[/FONT]