chrismpbi Tracker

Re: Split average of sum between start and end date

chrismpbi — Wed, 25 Jul 2018 10:59:49 GMT

Hi Jthomson,

This is just an example dataset. I have a few thousand lines with project costs. I would like to split those costs over the project duration. It would be good if I could also split it per day but its not necessary.

Christoph

Re: Split average of sum between start and end date

chrismpbi — Wed, 25 Jul 2018 09:00:44 GMT

Hi Yuliana,

thanks for your response! It seems to work but the month by which the amount is divided should be independent from the date filters. in the screenshot below the amount is just divided through the month that are in the selected year.

Split average of sum between start and end date

chrismpbi — Tue, 24 Jul 2018 14:54:58 GMT

Hi,

I would like to calculate the average of a sum and split it between the start and end date.

Hope somebody can help me with this. Chris

Re: Dax Date Comparison

chrismpbi — Tue, 17 Jul 2018 07:30:23 GMT

Hi ChrisMendoza,

thank you very much for your response. I think as you mentioned this solution would work for this example data set. But my real dataset is much bigger with hundreds of "Batch Dates".

Dax Date Comparison

chrismpbi — Mon, 16 Jul 2018 14:45:21 GMT

Hi,

I hope someone is able to help me with this:

I have a table with data from different batch dates and would like to compare the planned date versus the actual date at different batch dates.

ID	Batch Date	Actual Date	Planned Date
123214	04.05.2018		07.07.2018
43344	04.05.2018		08.07.2018
4545	04.05.2018		09.07.2018
123214	06.05.2018		11.07.2018
43344	06.05.2018	05.07.2018
4545	06.05.2018	03.07.2018
123214	07.05.2018	06.07.2018
43344	07.05.2018	05.07.2018
4545	07.05.2018	03.07.2018

For Example:

Planned date at Batch date 04.05. compared with Actual date at Batch date 07.05.:

	Planned at 04.05.Batch Date	Actual at 07.05.Batch	Days difference
123214	07.07.2018	06.07.2018	-1
43344	08.07.2018	05.07.2018	-3
4545	09.07.2018	03.07.2018	-6
Total			-10

I have tried using two different date tables (Previous and Current Date) that have an inactive connection to the batch date column but I can’t create correct measures for calculating the “days difference”.