summarize columns
1 Topic
Summarize 2 Columns with all possible options
Hi I have added a new table using SUMMARIZE. All seemed to be working fine but I have just realised that some "Customers" do not have all dates which I need to display. Is it is possible to create a table from 2 columns but displaying all possible combinations? Main Table = Summarize(Cases,Cases[Customer],Cases[CreatedMonthAndYear]) Data Example Customer CreatedMonthAndYear AA Feb 2024 BB Mar 2024 CC Apr 2024 Desired Output Example Customer CreatedMonthAndYear AA Feb 2024 AA Mar 2024 AA Apr 2024 BB Feb 2024 BB Mar 2024 BB Apr 2024 CC Feb 2024 CC Mar 2024 CC Apr 2024 Any Help would be great ThanksSolved725Views0likes2Comments