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.
Is there a way I can create a relationship between these 2 tables:
Currently the data has the header as months but the data underneath are scores:
I am trying to create a visualization that will show scores by month for each property.
Thank you for your assistance!
Solved! Go to Solution.
I'd strongly recommend unpivoting your data table.
https://learn.microsoft.com/en-us/power-query/unpivot-column
Then convert the month names into dates (e.g. "Apr" --> 4/1/2023) for the appropriate year so that you can create a relationship to Calendar.
I'd strongly recommend unpivoting your data table.
https://learn.microsoft.com/en-us/power-query/unpivot-column
Then convert the month names into dates (e.g. "Apr" --> 4/1/2023) for the appropriate year so that you can create a relationship to Calendar.
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.