Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. 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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
70 | |
42 | |
42 |
User | Count |
---|---|
49 | |
42 | |
29 | |
28 | |
26 |