Visualize Plan vs Actual

Used for anything related to the new Power BI Desktop and Service tools
CakzPrimz
Posts: 1
Joined: Mon Feb 17, 2020 7:01 pm

Visualize Plan vs Actual

Postby CakzPrimz » Mon Jul 19, 2021 9:48 pm

Hi Folks,

I am newbie in Microsoft Power Bi.
I have a data in Excel, I have only 5 columns.
1st columns (A): plan date (date)
2nd column (B): actual date (date)
3rd column (C): System number (string)

Within April 2021, we have a plan to finish 11 system numbers
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:
April 2021: finish 10 system numbers, finished in April 2021
May 2021: finish 7 system numbers, finished in April 2021
June 2021: finish 9 system numbers, finished in April 2021
August 2021: finish 4 system numbers, finished in April 2021

When I to insert a pivot table in Excel, the result of April 2021 is Plan = 11 and Actual = 10
What we want of the result of April 2021 is Plan = 11 and Actual = 30
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

I really appreciate it if someone could help me.

Thank you
prima - Indonesia

PhilC
Posts: 281
Joined: Tue Sep 09, 2014 8:13 am

Re: Visualize Plan vs Actual

Postby PhilC » Thu Jul 29, 2021 1:37 pm

Hi prima, this was a while ago, so you might have solved it.

You need to use multiple connections to a date table and use the date table on your visual.

See https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/ for an example, lots of other examples on the interent.

Cheers
Phil


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest

cron