Forum Discussion
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 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 |
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
2 Replies
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