The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
86 | |
85 | |
35 | |
35 | |
34 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |