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.
Is it possible to reference or record a DAX measure in Power Query?
Hey,
actually this is not possible.
You have to imagine the whole Power BI "Magic" as layered tricks:
The first layer are the queries that extract and transform data from data sources, most of the time the result of a query is a table that will be used in the data model.
The 2nd layer are calculated columns
The 3rd layer are measures
Each layer builds upon its predeccessor, for this reason slicer can not interact with calculated columns, meaning a selection in a slicer will not affect the calculation of a calculated column, it just filters the rows.
This "image" may explain, why it's not possible to reach out from a query to a measure.
Hopefully this helps
Regards
Tom
If i were to calculate my values in a column rather than a measure I should be able to circularly query this table?
I'm not entirely sure what you mean by that but in general, no. Power Query is M and you cannot use DAX in Power Query. What exactly are you trying to do?
I have measures calculating Daily, Weekly, Monthly totals. I am trying to record or store these values in a dynamic table upon refresh within PowerBI.
The issue is I can't do this in the database because this data is from an export from a third party vendor. I do not have access to the data source.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |