Multiple Dates

[Anonymous]

Hi All,

i have a Fact table that contains two date columns: 

a) Go Live (Start)

b) Go Live (End) 

I basically want to create a matrix like below, however, i'm confused since one date relationship will be inactive so how do i capture the full range of month-year i need? At the moment, i'm only getting month-year for the months shown in my active date column. How do i make sure that it's capturing all the dates from both Go Live (start) column and Go Live (end) column? 

	Jan-20	Feb-20	April-20	Sept-20
On Prem	8	7	8	7
Cloud	10	11	20	1

[nicolas_carrere · Accepted solution]

Hi,

You can try to create a table "calendar" with calendarauto() and a mesure :

Calculate(SUMX(data, data[colonne]), USERELATIONSHIP(calendar[date], data[Go Live (Start)])) + Calculate(SUMX(data, data[colonne]), USERELATIONSHIP(calendar[date], data[Go Live (End)]))

Where data is the table that contains your data

https://www.linkedin.com/in/nicolas-carrere/

[Anonymous]

Thanks so much!