Forum Discussion

Regular Visitor

4 years ago

Solved

mesaure dynamic text (Active or Expired) based on date Colum (Contract End Date)

Hello

I have card visual and i need to create mesaure dynamic text (Active or Expired) based on date Colum (Contract End Date)

for example :

the end date of contract A is 11/05/2021 the result should be in card visual = expired

the end date of Contract B is 11/05/2022 the result should be in card visual = Active

Thanks

Abdulazizsagga Try:

Column = IF(TODAY()>[End Date],"Active","Expired")

Measure = IF(TODAY()>MAX('Table'[End Date],"Active","Expired")

v-xiaotang
4 years ago
Hi Abdulazizsagga

If you want the card visual to show blank until you select one contract, you can try this,

Measure = IF(ISBLANK(SELECTEDVALUE('Table'[contract])),BLANK(),IF(SELECTEDVALUE('Table'[End Date])<TODAY(),"Expired","Active"))

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

v-xiaotang
Community Support
4 years ago
Hi Abdulazizsagga

If you want the card visual to show blank until you select one contract, you can try this,

Measure = IF(ISBLANK(SELECTEDVALUE('Table'[contract])),BLANK(),IF(SELECTEDVALUE('Table'[End Date])<TODAY(),"Expired","Active"))

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Abdulazizsagga
Regular Visitor
4 years ago
if date has passed compared with today’s date
- Greg_Deckler
  Community Champion
  4 years ago
  Abdulazizsagga Try:
  
  Column = IF(TODAY()>[End Date],"Active","Expired") Measure = IF(TODAY()>MAX('Table'[End Date],"Active","Expired")

Related content