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...
are you expecintg this output
1 1/1/2016 365 1111
1 1/2/2016 365 1111
1 1/3/2016 365 1111
1 1/4/2016 365 1111
1 1/5/2016 365 1111
....
so basically each campaign is broken down by date, with date difference between start/end date and plan value,c orrect?
above is just an example
Exactly, it could be only DAX measure - and then somehow link it to date dim. Or could be Power query script.
- Perfect, thanks A lot. I will check tommorow, i have now only mobile and Mac. Thanks!!