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.
Hello,
I am trying to add an index column. I need repeating dates to have the same index number. Any ideas?
Solved! Go to Solution.
You can highlight your Date column, hit the Group By button on the ribbon, and choose "All Rows" for the aggregation. While it's aggregated, add an Index column. Then expand the nested tables (uncheck the Date column from the Expand option, as you will already have it).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can highlight your Date column, hit the Group By button on the ribbon, and choose "All Rows" for the aggregation. While it's aggregated, add an Index column. Then expand the nested tables (uncheck the Date column from the Expand option, as you will already have it).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.