I'm creating a summarized table and I need to have an index number or row number. Search results lead to having index number using the Power Query but in my case, I need to have a summarized table.
My summarized table is just like this:
|Category||Index (I don't know how to have this)|
I tried this but I only get the same result:
Any help is appreciated. Thank you!
Solved! Go to Solution.
This would be done more easily in the query editor, but here is how to do it in a DAX table. There probably is a way to do it in one table variable, but I used two to make it easier. Replace with your actual table/column names.
New Table =
VAR table1 =
Category[Group] & Category[Category]
VAR table2 =
VAR thismerge = Category[Group] & Category[Category]
[merge] < thismerge
) + 1
Not sure what you mean by summarized table. Are you making a DAX table with SUMMARIZE? Or do you mean a table visual with the Category and Group columns? Please clarify.
Hello @mahoneypat !
Yes, I'm making a DAX table using the SUMMARIZE function. The above excel screenshot that I sent is my expected outcome from my DAX table. Thanks!
Btw @mahoneypat , how do I add this during the summarized formulas? Also, can I add index numbers based on group?
For example: (for some reason, I can't attach a table so I provided a sample screeshot)
Thanks in advance!
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.