Below is a dax code which is creating virtual table with 6 columns.
VAR A =
CROSSJOIN( SUMMARIZE( Destinations, Destinations[Dest]),SUMMARIZE(‘Material Master’,‘Material Master’[Material])),
“Forecast_Act_OrdersQty”, [Order Qty (Combined)],
“Forecast_OrdersQty”, [Supply Forecast(M-3 logic Based on Latest Forecast File)],
“Variance”, [Forecast Variance]
VAR B =
[Forecast Variance] > 0,
This dax query results in a table with 6 columns in dax studio . I am trying to create another table from the variable B table that will have 3 columns. First Column will be the unique or distinct values of [Dest] Column and the other two column will be the summarization of [Variance] and [FA_Denominator] column as per the [Dest] column.
I have done it using “Table” keyword which was recently introduced but “table” keyword is not working in PBI. It is only working in Dax studio.
Has anyone done anything like this before using variables only??