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

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