Forum Discussion

baBI123's avatar
baBI123
Helper II
8 years ago
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...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

baBI123's avatar
baBI123
Helper II
8 years ago

column 1=TAT
column 2= ACA
column 3= TAT NET

What do you think went wrong pxg08680 ?

  • pxg08680's avatar
    pxg08680
    Resolver III
    8 years ago

    baBI123

    Can you share the data...?

     

    • baBI123's avatar
      baBI123
      Helper II
      8 years ago

      unfortunately, I can not as there is private info on the document... do yu have any other suggestions pxg08680 ?

      • pxg08680's avatar
        pxg08680
        Resolver III
        8 years ago

        baBI123

        column3 has no data for few rows. So when you subtract it from column4 what do you expect the result to be...?

        Date - empty row = ...?????