Forum Discussion

imranamikhan's avatar
imranamikhan
Icon for Helper V rankHelper V
5 years ago
Solved

Cumulative Measures Two Date Columns One Date Table

Hi everyone,   Table A has a column with Customer IDs and a Date column (Record Timestamp). This table is linked to a Date table.   Table B has column of Customer IDs and a Date column (Modified ...
Need Help
  • imranamikhan's avatar
    imranamikhan
    5 years ago

    Thanks all. I just needed an example of applying the syntax - which I have now found.

    Cumulative Closed = CALCULATE (
DISTINCTCOUNT(DB_CustomerMasterData_Current_Report[MDStatus]),USERELATIONSHIP(DB_CustomerMasterData_Current_Report[Market Feedback Modified Date], 'CalendarAuto'[Date]),
FILTER (ALL('CalendarAuto'[Date]),
('CalendarAuto'[Date]) <= MAX ( 'CalendarAuto'[Date] )),DB_CustomerMasterData_Current_Report[Market Feedback Cleanse Status]="11. Closed")

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI imranamikhan,

It sounds like a common multiple date range analysis requirement, you can take a look at the following link 'start date', 'end date' part of it suitable for your requirement.

Before You Post, Read This 

Regards,

Xiaoxin Sheng