Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
evaluate(filter('Date_Dim', [Calendar_dt]=DATEVALUE("2021-01-01")))
can someone please suggest correct syntax to use Datesbetween function in Evaluate.
Thank you.
Solved! Go to Solution.
@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 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 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"))))
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |