Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
User | Count |
---|---|
84 | |
81 | |
64 | |
53 | |
45 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |