Forum Discussion

6 Replies

  • mattww's avatar
    mattww
    Responsive Resident
    4 years ago

    Anonymous , could you provide a bit more information on what your expected output looks like?

     

    Have you tried something like Split by Delimiter or Column from Examples?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      mattww This is the matrix table i am working on. 

      I am trying to end up with Somthing like this:

       

      where i add the two values together 

       

       

      • mattww's avatar
        mattww
        Responsive Resident
        4 years ago

        Thanks Anonymous 

         

        Ok, I would suggest creating a new column using Text.BeforeDelimiter in Power Query

         

        let
        Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCncMcQ1S0FVwC3J0VtJRMjE2NTQ3VYrVQcgEhPsCJXRNjA3NzYz0zAyVYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Description = _t, #"AFE-Field Est" = _t]),
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Description", type text}, {"AFE-Field Est", type number}}),
        #"Added Custom" = Table.AddColumn(#"Changed Type", "DescriptionSplit", each Text.BeforeDelimiter([Description]," - ")),
        #"Grouped Rows" = Table.Group(#"Added Custom", {"DescriptionSplit"}, {{"AFE-Field Est (agg)", each List.Sum([#"AFE-Field Est"]), type nullable number}})
        in
        #"Grouped Rows"

         

        The Grouping in Power Query may be unneccesary if you want to do your aggregations in DAX when building your visuals.

         

        Alternatively, you could create a dimension table to attach to your budget code.

         

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

         

         

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

     

    I noticed that your problem description has been deleted. Has the problem been resolved? If yes, could you accept the answer helpful as solution to help others find it quickly? If not, could you add more details so that we can help you further? Thanks 🙂

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.