Forum Discussion

itsmebvk's avatar
itsmebvk
Continued Contributor
5 years ago
Solved

Dates between function not working in Evaluate function?

Hi Geeks,   I am facing syntax issue. When I am trying to use Datesbetween function in Dax while using Evaluate. I am using Azure Analysis Service as source and using import mode.       e...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    itsmebvk , I think, with import mode it should work

     

    something like

    calculateTable(table, DATESBETWEEN(table[Data], date(2019,09,01), date(2020,02,29)))

amitchandak's avatar
amitchandak
Super User
5 years ago

itsmebvk , DATESBETWEEN return table , so this should work

evaluate(

DATESBETWEEN(DAte[Data], date(2019,09,01), date(2020,02,29))

)

  • itsmebvk's avatar
    itsmebvk
    Continued Contributor
    5 years ago

    amitchandak  Thanks for quick reply. I want to get all table columns but it should filter table only for between few dates. Is this expression works to achieve this requirement within evaluate function?

     

    Can I also use Direct query mode while using Azure Analysis Service model as source?

     

    Regards

    BVK 

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      itsmebvk , I think, with import mode it should work

       

      something like

      calculateTable(table, DATESBETWEEN(table[Data], date(2019,09,01), date(2020,02,29)))

      • itsmebvk's avatar
        itsmebvk
        Continued Contributor
        5 years ago

        amitchandak  Thank you.

         

        As suggested by you, I have used following expression and it worked like charm.

         

        evaluate(calculateTable('Fact_Table',DATESBETWEEN('Fact_Table'[Calendar_dt],DATEVALUE("2021-01-01"),DATEVALUE("2021-01-03"))))