Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ludd
New Member

Dates in columns and variable

Currently, I have an input like below with hundreds of extra columns:

CountryIDInitiativeCostmar-21apr-21
UK111003040
US221501211
IT32201411

 

How can I, without hard coding the current month (mar-21), identify the total per column which would be for UK = 30 and next month = 40? I need to create a new variable for current month.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

That is a rather unfortunate table design. Have you considered unpivoting your month columns?

View solution in original post

2 REPLIES 2
Ludd
New Member

Unpivoting does the trick. Thank you!

lbendlin
Super User
Super User

That is a rather unfortunate table design. Have you considered unpivoting your month columns?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.