topic getting a '1' or '0' based upon a date column and a condition column (Planned/Occurred) in DAX Commands and Tips

getting a '1' or '0' based upon a date column and a condition column (Planned/Occurred)

Anonymous — Thu, 09 Jul 2020 03:26:18 GMT

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 🙂

Re: getting a '1' or '0' based upon a date column and a condition column (Planned/Occurred)

HotChilli — Thu, 09 Jul 2020 12:43:38 GMT

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?

Re: getting a '1' or '0' based upon a date column and a condition column (Planned/Occurred)

Pete_MASS — Thu, 09 Jul 2020 13:34:00 GMT

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.

Re: getting a '1' or '0' based upon a date column and a condition column (Planned/Occurred)

sturlaws — Wed, 05 Aug 2020 20:13:39 GMT

Hi Anonymous

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