Forum Discussion

Pfin's avatar
Pfin
Frequent Visitor
1 year ago
Solved

Power BI - Excel To Power BI - Report Style Help Needed

I'm trying to recreate a report in Power BI that has long lived in Excel for YEARS where the user can basically create the format that has been used.  Any input on how to provide this same informatio...
Need Help
  • Fowmy's avatar
    Fowmy
    1 year ago

    Pfin 

    Use this measure:

    Data = 

CONCATENATEX(
    Table02,
    Table02[Model] & UNICHAR(10) &
    Table02[Price] & UNICHAR(10) &
    Table02[Available Date] & UNICHAR(10), "-----------" & UNICHAR(10)
)

     




Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

This M code works as well

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Manufacturer", type text}, {"Segment", type text}, {"Model", type text}, {"Price", Int64.Type}, {"Available Date", type date}}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Changed Type", {{"Price", type text}, {"Available Date", type text}}, "en-IN"),{"Model", "Price", "Available Date"},Combiner.CombineTextByDelimiter("#(lf)", QuoteStyle.None),"Merged"),
    #"Grouped Rows" = Table.Group(#"Merged Columns", {"Manufacturer", "Segment"}, {{"Count", each Text.Combine(_[Merged],"#(lf)-----------------#(lf)")}}),
    #"Pivoted Column" = Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[Segment]), "Segment", "Count")
in
    #"Pivoted Column"

Hope this helps.

 

  • Pfin's avatar
    Pfin
    Frequent Visitor
    1 year ago

    This is fantastic as well!  Thank you for the reply and help!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      You are welcome.  If my previous reply helped, please mark that reply as Answer.