Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

Calculating completion % based on expiry dates

Hi, I need some help working this brain teaser out, please.  FYI **Table at bottom. Financial Year runs 1st April - 31st March** I have a property company with 6 locations, and I conduct a variety...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    RichOB 

    I think I only find 3 ID for the first one.

     

    you can try  this

     

    Measure = DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Expiry Date]>=date(year(today())+1,4,1))),DISTINCTCOUNT('Table'[Property_ID]))
     
     
    for the second one ,you can try to create a column, 
     
    late num =
    var _next=minx(FILTER('Table','Table'[Property_ID]=EARLIER('Table'[Property_ID]) && 'Table'[Issue_Date]>EARLIER('Table'[Issue_Date])),'Table'[Issue_Date])
    return if (_next>'Table'[Expiry Date],1)
     
     
    pls see the attachment below
     
     
v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi RichOB 
FBergamaschi ryan_mayu Thanks for the inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi RichOB 

I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.

 

  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    Hi RichOB 

    Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. if you have any other issues please reach community.