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
103 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,460 points
87 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,890 points
89 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
14,329 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,460 points
322 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 51,890 points
278 views
0 votes
1 answer
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
191 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
1,168 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,060 points
283 views