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.
Hello fellow community,
Kindly help to solve the below problem;
Consider the tables below, they are implementation tracking reports for 3 quarters in FY 22.
I would like to achieve the following:
FY22Q1 Report | |||
Unique Issue Tracking Ref. | Quarter the Issue was raised | Implementation Status | Office |
123 | FY21Q1 | Open | Armenia |
124 | FY21Q3 | Closed | Sri Lanka |
125 | FY22Q1 | Partially Implemented | Senegal |
126 | FY22Q2 | Open | Ecuardo |
FY22Q2 Report | |||
Unique Issue Tracking Ref. | Quarter the Issue was raised | Implementation Status | Office |
123 | FY21Q1 | Open | Armenia |
124 | FY21Q3 | Closed | Sri Lanka |
125 | FY22Q1 | Partially Implemented | Senegal |
126 | FY22Q2 | Open | Ecuardo |
127 | FY22Q3 | Open | Armenia |
FY22Q3 Report | |||
Unique Issue Tracking Ref. | Quarter the Issue was raised | Implementation Status | Office |
123 | FY21Q1 | Closed | Armenia |
124 | FY21Q3 | Closed | Sri Lanka |
125 | FY22Q1 | Closed | Senegal |
126 | FY22Q2 | Open | Ecuardo |
127 | FY22Q3 | Open | Armenia |
128 | FY22Q4 | Partially Implemeted | Ecuardo |
There is no need to have three separate tables
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyVtJRcos0Mgw0BDL8C1LzgJRjUW5qXmYiRMYIKBOrA1JqAlMK0uOck1+cmgJkBBdlKvgk5mVjKDdFCOgoBSQWlWQm5uRUKnjmFuSkAs0vgehOzUtNT8xB12sGEzBCuMo1uTQxJb8IXSkRHjAizQNGFHjAiHgPwJSawwSMCXoAxa9wD6ApNibNt8bYfItQjuo9Y+K9Z0y892BKLWACJngCHNOaWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Unique Issue Tracking Ref." = _t, #"Quarter the Issue was raised" = _t, #"Implementation Status" = _t, Office = _t, Quarter = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Unique Issue Tracking Ref.", Int64.Type}, {"Quarter the Issue was raised", type text}, {"Implementation Status", type text}, {"Office", type text}, {"Quarter", type text}})
in
#"Changed Type"
Please indicate expected outcome based on this source data.
not working
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.