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.
Dear all,
I'm quite new to Power BI and try to deal with DAX more and more.
I would like to create a virtual Table with the following step and the 3rd step failed:
What did I wrong?
Solved! Go to Solution.
@Florian_Kluge , Try with these change , a new table
var Price_Index1 = ADDCOLUMNS('Price Index',"Quarters_from_now",related('Price Index Quarters'[Quarters from now]))
var Price_Index2 = SUMMARIZE(Price_Index1,Price_Index1[Material No], Price_Index1[Quarters_from_now], Price_Index1[Quarter Year], Price_Index1[Price],Price_Index1[Qty])
var Price_Index3 = CALCULATETABLE(Price_Index2, Price_Index2[Quarters_from_now]>3)
return Price_Index3
Does this work?
New Table =
SUMMARIZE (
FILTER ( 'Price Index', 'Price Index Quarters'[Quarters from now] > 3 ),
'Price Index'[Material No],
'Price Index Quarters'[Quarters from now],
'Price Index'[Quarter Year],
'Price Index'[Price],
'Price Index'[Qty]
)
Proud to be a Super User!
Paul on Linkedin.
Hi @PaulDBrown : Thanks a lot, this also helps if I put the
'Price Index Quarters'[Quarters from now] in the related function.
Thanks
@Florian_Kluge , Try with these change , a new table
var Price_Index1 = ADDCOLUMNS('Price Index',"Quarters_from_now",related('Price Index Quarters'[Quarters from now]))
var Price_Index2 = SUMMARIZE(Price_Index1,Price_Index1[Material No], Price_Index1[Quarters_from_now], Price_Index1[Quarter Year], Price_Index1[Price],Price_Index1[Qty])
var Price_Index3 = CALCULATETABLE(Price_Index2, Price_Index2[Quarters_from_now]>3)
return Price_Index3
@amitchandak: Thanks a lot, now I see it more a matter of the AutoCompletion, which does not present the column names of virtual tables
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 |