Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

DAX DATESBETWEEN

I have a list of campaigns, each record has a Start and Finish date associated with it.    I want to be able to get the MINX of Start, the MAXX of Finish, and populate another table with all the da...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Anonymous You should use New Table option under Modelling tab and then use DAX code you've got. From syntax it seems like you're trying to create a measure using DATESBETWEEN which returns table and so it is not working.

  • Anonymous's avatar
    Anonymous
    10 years ago

    Thanks for your replies - manged to do it with:

     

    Table = CALENDAR( minx(Campaign_Report,Campaign_Report[Start]), maxx(Campaign_Report,Campaign_Report[Finish] ))
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous You should use New Table option under Modelling tab and then use DAX code you've got. From syntax it seems like you're trying to create a measure using DATESBETWEEN which returns table and so it is not working.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Thanks for your replies - manged to do it with:

     

    Table = CALENDAR( minx(Campaign_Report,Campaign_Report[Start]), maxx(Campaign_Report,Campaign_Report[Finish] ))
    • BhaveshPatel's avatar
      BhaveshPatel
      Icon for Super User rankSuper User
      10 years ago

      If you think the problem is solved, Can you please mark it as a solution. So the thread can be closed.