Matrix Date

Hi Simon_Br ,

In the first instance, it sounds like you want to structure your fact table with help from the following: https://community.fabric.microsoft.com/t5/Desktop/Tutorial-Fill-All-Dates-Between-Start-Date-and-End-Date-Columns/td-p/2659679

This would give you a single date column that you could then join to your date dimension table (assuming you have one) which would allow you to visualise what you need via a matrix.

Hope that helps!

See this formula

let
    Source = Table.FromRows({{"A",	#date(2023,11,12),	#date(2023,11,15)},
{"B", 	#date(2023,12,31),#date(2023,12,31)},
{"C",	#date(2024,04,15),	#date(2024,6,5)}},{"Modell", "from", "to"}),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each List.Dates([from],Duration.Days([to]-[from])+1,#duration(1,0,0,0))),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
    #"Pivoted Column" = Table.Pivot(#"Expanded Custom", List.Distinct(#"Expanded Custom"[Modell]), "Modell", "to", List.Count),
    #"Removed Columns" = Table.RemoveColumns(#"Pivoted Column",{"from"})
in
    #"Removed Columns"

For more advance solutions, see the link of similar challnge on my linkedin page as below

https://www.linkedin.com/posts/omid-motamedisedeh-74aba166_excelchallenge-powerquerychallenge-excel-activity-7217996213822926849-XoCm?utm_source=share&utm_medium=member_desktop