Forum Discussion
Solved
DAX, Disaggregate PLAN data - start date, end date
Hello Comunity, I have source data in this structure: Campaign ID Start date End date Plan
888405244 01.01.2016 31.12.2016 726190
888405244 01.01.2017 31.12.2017 890145
873145821 01.01.2...
Hi Abduvali,
Thank your for your reply, but this is not what I want. My result is not concatenating Plan.
I need to recalculate the data (Plan column) by number of days in period (Between start date and end date). In order to be Able to be plot this plan on daily/weekly... level.
Regards,
Martin
Thank your for your reply, but this is not what I want. My result is not concatenating Plan.
I need to recalculate the data (Plan column) by number of days in period (Between start date and end date). In order to be Able to be plot this plan on daily/weekly... level.
Regards,
Martin
Martin-Prague to confirm based on your data set, plan for each row will be 365 days, correct?
- Hello, no the period is sometimes different, unfortunately. Start date and End date needs to be taken into calculation.
Understood, but in the sample you mentioned it will be difference between dates, and your sample data will return 365 days, correct?
or you want plan value do be divided by different in number of days.
- In my sample, yes. The difference should be 365. But this needs to be dynamic.
When i have Plan only for 1.1.2017 - 15.1.2015 then it shoud be recalculated by 15 for this campaign. And my dataset has also these shorter periods.