Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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