Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hey BI Community,
I may have a very simple question, but for some reason, I can not seem to find an answer to my problem. I am trying to put together a very simple formula that takes into consideration multiple columns and then outputs an expression. What I am trying to do is figure out how to list a column that will produce a "Late" text value. The formula is as follows:
Solved! Go to Solution.
Hi @Anonymous
Try
Late Open =
IF (
PurchaseOrdersData[Line Status] = "Open"
&& PurchaseOrdersData[Projected Date] < TODAY ()
&& PurchaseOrdersData[Projected Date] <> DATEVALUE ( "1/1/1900" ),
"Late"
)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @Anonymous
Try
Late Open =
IF (
PurchaseOrdersData[Line Status] = "Open"
&& PurchaseOrdersData[Projected Date] < TODAY ()
&& PurchaseOrdersData[Projected Date] <> DATEVALUE ( "1/1/1900" ),
"Late"
)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
This worked perfectly thank you so very much for you help!
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |