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 everyone, hoping someone can help me with this:
I have two tables:
- one is just a data table
- second is a copy and then summary of the first table where the summary finds the last fiscal year, which is a text field, with data for each category, also a text field (i.e. for blue there is data up to FY 2019-20, for red there is data up to FY 2020-21) using List.Last
When I try to merge the two tables on the category field, I get weird data in that last fiscal year column (i.e. for blue it puts FY 2016-17 instead of 2019-20).
I can't share the data unfortunately, but any help would be great!
Hi @ElenaRodriguez ,
I understand you can't share your actual data, but can you provide a representative example using Enter Data in Power Query or similar?
It's very difficult to understand what the issue is and what might cause it without being able to see data types/structure etc.
Pete
Proud to be a Datanaut!
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.