Forum Discussion
arutsjak90
Helper I
Helper ICreate top 2 table per category with sku
HI, I am trying to create new table with top2 values per category. Category SKU QTy A 1 10 A 2 5 A 3 15 A 4 2 B 5 6 B 6 7 B 7 9 C 8 12 C 9 7 ...
OK, resolved. I have created new column using rankx, then I have created new table using CALCULATE TABLE (SUMMARIZE(), RANK <3). Thank you for your help.
arutsjak90Helper I
Helper IHI Vera_33, thank you for your hard work! 😊 I'am not sure and I didn't mention that but if my current table is a calculated table (summarize) then I can not use it in M? If so, dax is a only way, ofc in my beginner opinion.
arutsjak90Helper I
Helper IOK, resolved. I have created new column using rankx, then I have created new table using CALCULATE TABLE (SUMMARIZE(), RANK <3). Thank you for your help.