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 all,
after getting my data from an Excel sheet, I want to add a column with the name of the worksheet (not the workbook) as a value.
Example:
I get my data from Actuals2018.xlsx with sheets January , February , March , ....
The table in the sheet January has three columns as follows:
Date - Customer - Amount
I want to add a column named "Month" whith the value of the worksheet name which is "January" in this example.
Can someone help me out?
Thank you very much in advance!
Br,
Ruben.
Solved! Go to Solution.
@ruben_BE,
Yes. You can create a custom column based on the Date field.
Date.MonthName([Date],"en-us")
Regards,
Lydia
@ruben_BE,
In Power BI Desktop query editor, you can add a column from an example for each query.
Regards,
Lydia
Hi Lydia,
thank you for reply.
When applying this method, I don't get to adding the 'Table name' or de 'Worksheet name' as a value in a new column. I can only create a new column based on values in other columns.
Thank you very much for your assistance!
Best regards,
Ruben.
@ruben_BE,
Yes. You can create a custom column based on the Date field.
Date.MonthName([Date],"en-us")
Regards,
Lydia
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.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |