If invoice date is <= OTD then OT else Late and if OTD is blank then OT

0 votes

I am getting an error message. I am trying to do 2 statements in one. 

If Invoice Date is <= OTD Date + 1 day then OT else Late and of OTD Date is blank then OT 

Line OTD =

IF(

OR(IF(

Shipments_Data[Invoice Date] <= Shipments_Data[Sales Ord Ln OTD Date]+1, "OT", "Late"),

IF(

AND( Shipments_Data[Sales Ord Ln OTD Date] = blank, "OT"

)

))))

Thanks

Jun 30 in Power BI by lcallicutt
• 120 points
154 views

Hello @ lcallicutt ,

Can you please provide more information about what error you are getting and what you are trying to do?

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

+1 vote
2 answers

If and Else Statement to use in operator

Hey @Megha. I am new to Power BI ...READ MORE

answered Aug 29, 2019 in Power BI by anonymous
• 32,490 points
117 views
0 votes
1 answer

Is government, academic and nonprofit pricing available for Power BI?

Yes, nonprofit pricing is available when purchasing ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 51,970 points
105 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 22, 2019 in Power BI by VNK
15,802 views
0 votes
1 answer
0 votes
1 answer

Calculate age from dob field and another date value using slicer

Hi Karthick, Create a parameter with year range ...READ MORE

answered May 17, 2019 in Power BI by anonymous
• 32,490 points
517 views
0 votes
1 answer

What is the difference between PowerPivot, Power Query and Power BI?

Power Query Power Query is a self-service ETL ...READ MORE

answered Sep 24 in Power BI by Gitika
• 51,880 points
38 views
0 votes
1 answer
0 votes
1 answer

DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

answered Sep 24 in Power BI by Gitika
• 51,880 points
102 views
0 votes
1 answer
0 votes
1 answer

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

answered Sep 28 in Power BI by Gitika
• 51,880 points
55 views