Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |