Know if we are 50% or Halfway there based on a criteria on a dimension table.

[v_mark]

For context I need to know if we are halfway there based from created date and target date per specific priority number and return "at risk" else "open". On a calculated column

For example: This example should return "at risk" since the target date is pass over the 28/01/2023.
Determining how many days it will go over can be found on the dimension table.
I just divide the days timeframe into 2 and round  it up. 

I have a dimension table and fact table that has these information 

Sharing the Sample PBIX.  50% Sample.pbix

[v-cgao-msft · Accepted solution]

Hi @v_mark ,

Please try this.

Status 2 = 
VAR _50_date = 'FactTable'[Created date] + RELATED(TimeFrameTable[50% of Days])
VAR _result = IF(ISBLANK('FactTable'[Close Date]) && 'FactTable'[Target Date] > _50_date, "At Risk", "Open")
RETURN
_result

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum