cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Summarizing columns from three different date ranges(Please let me know if this the correct approah)

I have created a report that would filter based on three date ranges as below

 

 

 

DateFilterRange = IF(MAX(vw_patientListNew[StatusDate]) in UNION(VALUES(DateRange1[Date]),VALUES(DateRange2[Date]),VALUES(DateRange3[Date])),1)

 

 

 

roopesh_0-1596026790732.png

Now i want to summarize it like the table below

 TimeFrameDateRangeCol1TimeFrameDateRangeCol2TimeFrameDateRangeCol3
Interventional TX236512
Interventional Non TX13419

 

 

 

TimeFrameDateRangeCol1 = 
IF(MAX(vw_patientListNew[StatusDate]) in VALUES(DateRange1[Date]),1)
TimeFrameDateRangeCol2 = 
IF(MAX(vw_patientListNew[StatusDate]) in VALUES(DateRang2[Date]),1)
TimeFrameDateRangeCol3 = 
IF(MAX(vw_patientListNew[StatusDate]) in VALUES(DateRange3[Date]),1)

 

 

TimeFrameDateRangeCol1, TimeFrameDateRangeCol2, TimeFrameDateRangeCol3  are calculation column and should return 1 when the statusdate intersect the respective filter. As you can see i am not able to achieve with the Daxcode.

 

Once i get the values for the each collumn TimeFrameDateRangeCol1, TimeFrameDateRangeCol2, TimeFrameDateRangeCol3 i can summarize TimeFrameDateRangeCol1, TimeFrameDateRangeCol2, TimeFrameDateRangeCol3 to create a summary table.

 

Is there another solution to this? 

 

12 REPLIES 12
Highlighted

Hi @Anonymous,

 

Not really sure what you mean selecting the value in the table created it does not filter the table, what detail visual are you referring to

Highlighted
Anonymous
Not applicable

Hi @richbenmintz  i am referring to another table visual I added that contains a list of statusdate and intervention type

roopesh_0-1596034089074.png

 

Highlighted

Hi @Anonymous,

 

Given that your date dimensions are not connected to the fact table, you will need to include the measure in your detail visual.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors