Group Multiple Values into One Values on Month

Hi CuriousGuy001 

Here's a concise action plan to help you achieve this:

1. Create a Calendar Table: If you haven't already, create a calendar table that covers the entire range of dates present in your sales data. This table should include columns for Year, Quarter, Month, and Date at a minimum. You can use DAX to create this table. For more details on creating a calendar table, please refer to the Creating Calendar Table in Power BI using DAX Functions - RADACAD documentation.
   
   

2. Establish Relationships: Ensure that there's a relationship between your calendar table and your sales data table ('Margin Report' in your case) based on the date columns. 
   
   

3. Modify Your Matrix Visual: In your matrix visual, use the Month column from your calendar table as the row or column headers to group your data by month. This will automatically aggregate your sales data by the months.
   
   

4. Adjust Your DAX Calculation: If necessary, adjust your DAX calculation to reference the appropriate date column in your calendar table instead of directly from the 'Margin Report' table. This ensures that your calculations are leveraging the structured and consistent date information from your calendar table.

Best Regards,

Jayleny

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