Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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[Da...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
6 years ago

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.