Forum Discussion

sureshsonti's avatar
sureshsonti
Helper 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 () )
    )
)

     

sureshsonti's avatar
sureshsonti
Helper II
7 years ago

 

 

  

These are my fields in my Data Set. I am trying to avoid filters on the report.

Order Date
Year
Month
Location
Units Sold

 

1. I want to extract Units Sold Month To Date of Current Year based on Order Date
2. I want to extract Units Sold Month To Date (Last Year) based on the Order Date

 

Want to compare Units Sold Month To Date of Current Month and Last Year Month To Date of the Same Month using DAX formula. Trying to avoid filters on the report

 

Example December 2018 vs December 2017

 

Thanks for your help

 

Thanksdata.JPG

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi sureshsonti,

 

I would suggest you create a new post in this forum with a sample that can be copied or downloaded. It's a new topic. 

 

Best Regards,
Dale