Forum Discussion

luqmaanr's avatar
luqmaanr
Frequent Visitor
7 years ago

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...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Luqmaan,

 

How does the solution read from the Export sheet? I can't see any connections between these tables.

 

Best Regards,
Dale

luqmaanr's avatar
luqmaanr
Frequent Visitor
7 years ago

Hi Dale

I think we had some misunderstanding here:

1) The real data is the export work sheet

2) the other screenshot (which is in my ‎11-23-2018 post) I sent you is an example of what I want to achieve with Export work sheet using Power BI. The screenshot was completed in excel.

 

Thanks

Luqmaan

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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

  • luqmaanr's avatar
    luqmaanr
    Frequent Visitor
    7 years ago

    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