topic Re: Check if a contract has a future contract associated to it in DAX Commands and Tips

Check if a contract has a future contract associated to it

nabu — Mon, 13 Jun 2022 21:55:37 GMT

Hello, I have a file with contracts that are categorized by status as either expired, active or future based on the valid from and valid to dates. I want to add a Renewal Status column that checks unique contract numbers and lets me know that contract number has a future contract associated with it or not like the output example below.

Thank you in advance

Input

Output Column is Renewal Status column

Re: Check if a contract has a future contract associated to it

vapid128 — Mon, 13 Jun 2022 22:07:10 GMT

emmmmmmmm.

add colnum

index =

switch(true(),

[Status]="Expired",1,

[Status]="Avtive",2,

[Status]="Furture",3,

)

add colnum

Renewal Status=

If(calculate(max(index),allexpert(table, table[Contract #])=3,

"Future contract exists",

"Futrue contract does not exist"

)

Re: Check if a contract has a future contract associated to it

nabu — Mon, 13 Jun 2022 22:34:54 GMT

Thank you, that worked!!