Forum Discussion
Solved
new calculated column using dates
Hello, I was wondering if anyone could help me with a DAX formula for a new calculated column.. I need it to do the following: ([Last Ship Date]- [Entry Date]) - ([Quote Approved] - [Quote Date...
Hi baBI123,
Please create calculated columns referring to below formulas:
diff1 = IF ( Table1[Shipdate] > Table1[Entrydate], DATEDIFF ( Table1[Entrydate], Table1[Shipdate], DAY ), DATEDIFF ( Table1[Shipdate], Table1[Entrydate], DAY ) ) diff2 = IF ( Table1[Approveddate] > Table1[Quoteddate], DATEDIFF ( Table1[Quoteddate], Table1[Approveddate], DAY ), DATEDIFF ( Table1[Approveddate], Table1[Quoteddate], DAY ) ) NET TAT = IF ( Table1[Shipdate] = BLANK () || Table1[Quoteddate] = BLANK () || Table1[Approveddate] = BLANK (), 0, Table1[diff1] - Table1[diff2] )Best regards,
Yuliana Gu
I have taken top 3 rows from your data for first two columns and looking through other dates i have taken dates randomly for rest two columns.
And then I did these steps,
And then another column
Final result
The 3rd row gives some weird result because I entered 207 instead of 2017 for EntryDate(my bad). But rest all is working fine.
Hope this helps.
HI pxg08680Step 1 worked like a charm:smileylol:, thank you for that!
...However, I am having an issue with step 2, could you look at the picture and give me some insight?
Thank you
error message