Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
    9 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
    9 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
9 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
9 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
    9 years ago

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