Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
92 | |
86 | |
76 | |
64 |
User | Count |
---|---|
137 | |
113 | |
107 | |
98 | |
92 |