Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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-20Feb-20April-20Sept-20
On Prem8787
Cloud1011201
1 ACCEPTED SOLUTION
nicolas_carrere
New Member

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/

View solution in original post

2 REPLIES 2
nicolas_carrere
New Member

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
Not applicable

Thanks so much!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors