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 Martin-Prague,
Just create new quick measure and select Concatenated List of Values
- For more details check the video on my channel: How to create new quick measure for Concatenated List of Values in Power BI
Regards
Abduvali
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.
