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] ))
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

It seems to me that you are confused with your requirements. Can you please clearly explain what do you mean by 

 

"populate another table with all the dates inbetween the lower and upper range."  Posting Sample data and expected output would be highly appreciated.