Nested Filter? Trying to find amount for last non-zero date

Harsh · June 28, 2020, 6:53pm

Thank you for posting your query onto the Forum.

I’m attaching the working of my file for the reference.

If you’re following the New Date table code which was recently updated then in that case you can filter it out and have the actual value instead of blank.

You can try out this formula and check if it works for you -

Last Acct 1 BAI 45 = 
IF( LASTDATE( Calendar[Date] ) > TODAY() , 
          BLANK(), 
               CALCULATE([Sum of Acct 1 BAI 45 Amount],
                      FILTER(‘Calendar’,‘Calendar’[DayID] <= MAX(‘Calendar’[DayID])))`

Please Note: The naming convention might differ in your file so you can use it accordingly.

I’m also providing a link where similar sort of problem was faced by one of the member and got solved.

Hoping you find this useful and helps you in your analysis.

Thanks & Warm Regards,
Harsh

MTD Measure showing Blank

eDNA Forum - Max Date Filter Solution.pbix (128.9 KB)