Forum Discussion

Martin-Prague's avatar
Martin-Prague
Icon for Helper II rankHelper II
8 years ago
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...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Martin-Prague

     

     

    Hi, Please check this PBIX Here

     

    In Query Editor .

     

     

     

    Let me know if works

     

    Regards

     

    Victor

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Martin-Prague to confirm based on your data set, plan for each row will be 365 days, correct?

Martin-Prague's avatar
Martin-Prague
Icon for Helper II rankHelper II
8 years ago
Hello, no the period is sometimes different, unfortunately. Start date and End date needs to be taken into calculation.