Forum Discussion
Visualization in Power BI
I am new to Power BI but able to manage around few times. I am struggling to create cumulative of the data that I have. and some on time %. My file contains the following screenshot below. My visua...
Hi Luqmaan,
Yes, that's my assumption. You verified that. Now the question is how you will do to get the result without Power BI. Then I can do it in Power BI.
I have the sample file. But I don't know the logic from the real data to the result.
Best Regards,
Dale
hi Dale
1) I would count the number of Packages that are associated within that month for specific miletones (=COUNTIFS(POP!AR$4:AR$52,"<"&$AM7) - AM7 today's date
2) for the cumulative, I would take the total from previous month and add it with the actual month for e.g. if Jan 2018 I had 2 Packages completed and and in Feb 2018 I had 5 Packages completed, then my cumulative should be 7.
How could I add an attachment to this forum. Then I can send you the excel file.
thanks
Luqmaan