Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm not sure this question has been asked before, but I've been trying to improve my DAX skills a bit and I'm now looking at EVALUATE in DAX. I know it returns a table, but since it cannot be used in a calculated measure nor a calculated column, where can I use this function in Power BI or in Power Pivot?
Thanks for helping!
Solved! Go to Solution.
DAX can be used as a Query language. This is when you would use Evaluate. You can use a tool like DAX studio to query the data model. Read my article about DAX Studio that includes some examples here http://exceleratorbi.com.au/getting-started-dax-studio/
DAX can be used as a Query language. This is when you would use Evaluate. You can use a tool like DAX studio to query the data model. Read my article about DAX Studio that includes some examples here http://exceleratorbi.com.au/getting-started-dax-studio/
Hi @MattAllington, I had the same question as @webportal. I thought I could return a table or matrix visual using evaluate. Anyway, can an evaluate query created in DAX studio be imported to or be called from Power BI Desktop?
Proud to be a Super User!
In Power Pivot and Power BI, a table is the organisation of data in a tabular format. It can be...
So to your question
I thought I could return a table or matrix visual using evaluate.
If you want to return a table (1 above), you can either:
I hope that helps.
Hi Matt
Many thanks for clarifying this for me I have been furiously teaching myself Power BI and DAX for a new role that I am taking on, I have been using your text "Learn to Write DAX" which gave me an excellent grounding using your examples and questions applied to report tables in PBI. Together with "The Definitive Guide to DAX" my knowledge is expanding but the problem that I sometimes face (which you have now cleared up for me in this instance) is that it is not always immediately clear where some of the DAX functions sit within a Power BI context.
Regards
AB
Hell Matt,
Thank you so much, I'll read your article.
I like to understand things...
Best
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |