Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
106 | |
88 | |
64 | |
63 |