Forum Discussion
Running Cumulative Total Weekly
Hi,
This measure works. Download the file from here.
Measure1 = if(ISBLANK([Actual Time]),BLANK(),CALCULATE([Actual Time],DATESBETWEEN('Date 1'[Date],CALCULATE(MIN('Date 1'[Date]),ALL('Date 1'[asBUILT Weekday])),MAX('Date 1'[Date]))))
Hope this helps.
Hi Ashish,
Thanks very much for the help.
See whether you can open this link
My raw data for this excel is from Query, which is from a folder and automatic refresh once data been dropped into the folder.
Do I need to share the folder to you too?
Hi,
In the Date Table, there should be a way to get the Week and Weekday columns (which are presently in your Timekeeping Table. If that can be done, the we will drag those two columns from the Date Table to the visual and write a simple measure to get your desired result.
Can you somehow do that?
Yes, I can add a new column in Power Query under the "TimeKeeping_ActualTime", and extract Year and Week and WeekDay from this Date colunn. So all date information are all under "TimeKeeping_ActualTime" Table, and there is no need to have this Date Table. And all those newly added calculated columns can be added as slicer.
Because my current Cumulative measurement does not use anything from Date Table, and I plan to delete this table.
Or, I can do the Date as a new table/sheet and connect to the existing PowerPivot Table, and build ulti-to-one relationships between "TimeKeeping_ActualTime" and "Date" tables.
Which way you prefer me to do?
Are there any difference?Hi,
I want those two columns to be added to the Date Table. Your relationship for now is just fine.
Cool, I will do it right now.
When I am done, I will share the link of the file again.
Again, tks very much for the help.