Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have table with expite date for each products.
I wanted to make a conditional column with icon that shows those product under 30 days that expire it gonna have yellow icon and the less than 0 gonna be red icon and those products that have over 30 days expieration gonna have green icon with this measure
Solved! Go to Solution.
@selected_ ,
Conditional formatting is correct.
In my opinion, you need to create different logic for calculated field.
Try this:
@selected_ ,
Here are some examples:
@nandic This is great example for my case too. However, I also have the blank value in date field. How is the formula should I add to check blank value. I added one line below (in red) but doesn't work.
i'm getting the same error.
@selected_ ,
Conditional formatting is correct.
In my opinion, you need to create different logic for calculated field.
Try this:
Thanks it worked. Is that possible to make another measure on amount product will expire within 30 days and 60 days and 180 days?
@selected_ ,
Here are some examples:
Hi Nandic
I tried using your solution and Power Query is throwing me an error. I created a new custom column and entered this Fx
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
70 | |
67 |