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 , 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"))))