In a Matrix Visual previous Sales (invoiced values) and Forecast Sales (open Order values)

[Anonymous]

Dear Community,

I try since days to create a Matrix Visual with the above Sales. But it doesn´t work.

I hope someone can help me.

Thank you in advance

Mary

[Anonymous · Accepted solution]

Hello, thank you for your solution. On the end I split the table in 2 tables. One with open Orders and one with Net_Sales. Both connected with a Datetable and a Date range for each tables.

[marcosvin]

Hello!

I believe that the ideal way would be for you to join the columns "Net_sales_LC" and "open Orders Sales_LC" in a single column. You can do this in PowerQuery using the "Append" operation or create a new DAX metric using the SWITCH command to switch between previous sales and the forecast. Would that work?