Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
how is it possible to create the result table below in power query (preferred because of data compression) or dax? Perhaps it could solve the blank values and runnung total's base value calculation problems what I detailed in my previous post:
Running Total calculation based on criteria
Here is the link to the file for sample data: CombineMaterialAndYearMonthTables
Thank you in advance!
Solved! Go to Solution.
Hey @EnderWiggin ,
I don't really know what the column "Value" should be as it's only zeros. But you can get the table with a crossjoin. In DAX that would be as a new table:
ResultTable = CROSSJOIN( MaterialTable, PeriodTable )
But you can also do it in Power Query, what is a little more elegant. Here you just have to add a new column and refer to the second table in the column. Check my example:
Hey @EnderWiggin ,
I don't really know what the column "Value" should be as it's only zeros. But you can get the table with a crossjoin. In DAX that would be as a new table:
ResultTable = CROSSJOIN( MaterialTable, PeriodTable )
But you can also do it in Power Query, what is a little more elegant. Here you just have to add a new column and refer to the second table in the column. Check my example:
User | Count |
---|---|
94 | |
87 | |
79 | |
76 | |
69 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |