Forum Discussion
Helper ICalculate totals per date
Hi, Foolke
take a look at this sample report I created based on your sample data, is it something like this you are after?
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Resident RockstarHi, Foolke
take a look at this sample report I created based on your sample data, is it something like this you are after?
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
FoolkeThx sturlaws , for some reason didn't see your answer.
Your sample report is excactly what I need.
Unfortunatly ... it doesn't work for me.
- sturlaws
If you look at you creation date and closed date, there is a time part, e.g. 01.10.2019 22:31:29. The values in the date table are only dates, or they are like this 01.10.2019 00:00:00, so you won't get a match between the two tables.
You can split these creation/closed date into two columns using power query, one with date, the other with time.
Or you can create a calculated column where you remove the timepart of the creation date:
new column = left(creation date;9)Just remember to change the relationships to use the new column