Forum Discussion

e175429's avatar
e175429
Icon for Helper IV rankHelper IV
1 year ago
Solved

Tracking Totals by Dates

Hey all,   This is a sample of my data. The actualy data has over 15k records and I would love to upload the whole thing here to make it easier but I don't know how.   I am trying to track the pr...
  • techies's avatar
    techies
    1 year ago

    Hi e175429 not able to upload file, there is active relationship between prepared date and date, 

    inactive between approved date and date right?

SreeniBattula's avatar
SreeniBattula
Icon for Helper II rankHelper II
1 year ago

1. Create a Date  table using CALENDAR(MIN(PreparedDate), MAX(PreparedDate))

2. Create following  2 measures 

Count of Prepared =
CALCULATE(
COUNTROWS(Base),
NOT(ISBLANK(Base[PreparedDate])),
USERELATIONSHIP(Base[PreparedDate], 'Date'[Date])
)

 

Count of Approved =
CALCULATE(
COUNTROWS(Base),
NOT(ISBLANK(Base[ApprovedDate])),
USERELATIONSHIP(Base[ApprovedDate], 'Date'[Date])
)

3. Buld the visual using year and month from Date table and the mesures from the Base tabel

  • e175429's avatar
    e175429
    Icon for Helper IV rankHelper IV
    1 year ago

    Thank you for your assistance.

     

    I created the date table:

     

    I am getting the following error: