Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I asked this recently in another post but the advised steps did not work,
I am looking to create a column based on the following two columns. I am trying to get any items listed as 'planned' in the 'Interaction column' but have past there 'date of interaction' date to show as a value (1) - I will refer to thesae values in this post as 'Overdue'. Items listed as planned that are still in the future would not show.
The resulting column would show a '1' for enteries not being overdue and a '1' being in place where the entries are overdue, likewise items not overdue (having been tagged as planned but where the date falls in the future) would show a '0' value.
I would appreciate any and all help 🙂
Hi @Ankap
Do you still have issues with this?
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!
Cheers,
Sturla
Hi, I've just done a very similar problem. My way may work for you. I made a new column
CalDueStatus = IF([Calibration Due]>TODAY(), 1, 10)
I used 1 & 10 for testing. Then another column with conditional formating (as per attached) to get the RAG effect.
Hope this helps.
If you post the data (not a picture) and show the desired output I am sure we can get this solved.
Can you also clarify this part "The resulting column would show a '1' for enteries not being overdue and a '1' being in place where the entries are overdue" - this will get cleared up if you can show the column in your desired output.
I see the data in 3 categories:
Planned, earlier than today or today --> Overdue so show 1
Planned, later than today --> 0
Occurred. --> 0
Is that right?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |