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?

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

Are you able to upload your pbix file?

 

This is what I did:

 

This is what I got:

 

 

techies's avatar
techies
Icon for Super User rankSuper User
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?

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

    Thank you!

     

    I had it backwards:

    My active relationship was between approved date and date and my inactive relationship was between prepared date and date. Once I switched them, I got the correct visual:

    Thank you sooooo much!