Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple Dates

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 relati...
Need Help
  • nicolas_carrere's avatar
    nicolas_carrere
    5 years ago

    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/

nicolas_carrere's avatar
nicolas_carrere
New Member
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

Thanks so much!