Forum Discussion

sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
8 years ago
Solved

TODAY function

Hello, I have a table with Order Date and Scheduled Qty. I created a measure to display today's orders using the TODAY function in DAX. But after 7 PM the report shows tomorrow's orders.   Please ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi sureshsonti,

     

    The Service uses UTC time. Maybe you can try the formula below.

    Yardage =
IF (
    UTCNOW () = NOW (),
    CALCULATE (
        SUM ( YORX[Qty] ),
        FILTER ( 'YORX', 'YORX'[order_date] = DATEVALUE ( UTCNOW () + TIME ( 5, 0, 0 ) ) )
    ),
    CALCULATE (
        SUM ( YORX[Qty] ),
        FILTER ( 'YORX', 'YORX'[order_date] = TODAY () )
    )
)

     

alexei7's avatar
alexei7
Icon for Continued Contributor rankContinued Contributor
8 years ago

Hi sureshsonti,

 

That is odd - are you able to share the data model so that we can investigate? If the model contains sensitive data maybe you could remove it?

 

Thanks

Alex