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.
Hi!
How to create/append a index(1,2,3,4,5...) column in existing table with dax without using any condition or filter formular.
Thanks. Any help is appreciated!
Thank you so much for the answer. I looked at the links you provide to me , but UNION() claim to have the same number of columns in both joined table. In my case I have a table of 9 columns, I want to append another column with a series of number.Here is example of table to demontrate:
Name | Location |
Marry | A |
Aida | A |
John | B |
Mgdalena | C |
John | E |
Now I want to apend column called index at the end with series of numbers such as 1,2,3,4,5...
I know GENERATESERIES() can provide this series but then how I can add it to that table so that it become:
Name | Location | index |
Marry | A | 1 |
Aida | A | 2 |
John | B | 3 |
Mgdalena | C | 4 |
John | E | 5 |
Thanks
@Muzda
You can an Index column in Power Query
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Muzda
The question is not clear, please have a look at the UNION function:
https://docs.microsoft.com/en-us/dax/union-function-dax
https://www.youtube.com/watch?v=P-Pov3Fz_Ig
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.