Forum Discussion
Brandaris
Helper I
1 year agoExpected turnover per month
Hello PowerBI specialists, I hope you will have the "golden solution" for my challenge: I am looking for the (set of) DAX formula(s) (with usage of VAR or something), to calculate the following...
Brandaris
Helper I
1 year agoHello v-vpabbu,
Thanks for your help, but I'm afraid I didn't explain my questio good enough.
In my example Prospect A will start on 18. september 2025, so there are 104 days remaining this year.
So the real outcome should be as follows:
I think we have to make a table with dates (or Months) after the first delivery date (i.c. 18 september) until 31 december, so the first (partitial) month included, with per Prospect the expected turnover in the 4 last months of 2025
With kind regards,
Brandaris
v-kathullac
Community Support
1 year agoHi Brandaris
I’ve taken a sample dataset and applied the above logic to it.
Attaching a screenshot for your reference.
Let me know if you need any changes or further details.
Happy to help!
Regards,
Chaithanya.