Record DAX Measure with Power Query

[Kharvok]

Is it possible to reference or record a DAX measure in Power Query? 

[TomMartens]

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 

[Kharvok]

If i were to calculate my values in a column rather than a measure I should be able to circularly query this table?

[Greg_Deckler]

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?

[Kharvok]

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.