Forum Discussion

Martin-Prague's avatar
Martin-Prague
Helper 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

Martin-Prague's avatar
Martin-Prague
Helper II
8 years ago
Exactly, it could be only DAX measure - and then somehow link it to date dim. Or could be Power query script.
parry2k's avatar
parry2k
Super User
8 years ago

done, here is the link, look at plan table.

 

  • Martin-Prague's avatar
    Martin-Prague
    Helper II
    8 years ago
    Perfect, thanks A lot. I will check tommorow, i have now only mobile and Mac. Thanks!!