Better idea to display the datetime difference by DAX


  • Hello Friends,


    My customer request to show the "waiting time "as XX "d" XX "h"(eg. 3d4h, which means 3 days and 4 hours). So the calculatioon is straight enough as TODAY-orderDate.  I use the DAX to archieve this by 

    =IF(1.*(TODAY()-FactOrderLine[OrderFulldate])>=1, Round(1.*(TODAY()-FactOrderLine[OrderFulldate]), 0) & "d "& Mod(ROUND(24.*(TODAY()-FactOrderLine[OrderFulldate]),0), 24) & "h",ROUND(24.*(TODAY()-FactOrderLine[OrderFulldate]),0) & "h")

    But I am not sure whether this is the easiest way to do this.

    I doubt so. Any better and easier idea to implement this?


    terça-feira, 10 de abril de 2012 18:04


  • Hi Derek,

    Since you want to customize the date's format rather than the standard format, you have to construct its string just like you mentioned.

    Challen Fu

    TechNet Community Support

    quinta-feira, 12 de abril de 2012 05:50