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
HELLO pxg08680 ..... so.... I think what we are going to do is use the same data (and keep the formulas you gave me because they work GREAT!) but we need a way to calculate [NET TAT]...
If there is no value in [Last Ship Date] and [Qute date] and [Quote approved], then I neet [NET TAT] to be 0.
Do you have anyway to figure that out?
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
THANK YOU v-yulgu-msft !! And thank you for all you help pxg08680! I appreciate it.