Google Drive Link
I am new here as well as new to Power Bi.
I have learned the basics and have working level understanding of baisc excel and DAX formulas and associated syntax. I am trying to build a dashboard for my organization. Have tried everything with trial & error, looking up on the web but still am unable to figure out the way out. Please check the attached excel file (same file uploaded on Google Drive & One Drive).
I have a table (~ 1M rows) where each row represents one item. Each item is assoicated to
a) AREA - "1" or "3"
b) Conducted in - "S" - Shop or "F" - Field
c) Carried out by different Subcontractors - "A1", "A2", "A3"
The table has multiple date colums corrosponding to different activities on specific item (in some cases the activity is required, in some not). The activities are "X1", Y1" & "Z1".
I have created a date table separately which contains all unique dates and WEEKNUM. 1-to-many relationship has established the tables.
I now intend to data Matrix visualition and line chart as shown in the table. The data is pulled on weekly basis. So KPIs are calculated on weekly totals and Cumulative (Rolling Sum) totals. Please help in any possible way. Also available for suggestions if the data can be presented in a better way.
PS: I have access to Office 365 & PRO license, so no limitations on any specific service.