TODAY function

[sureshsonti]

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 help

[alexei7]

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

[sureshsonti]

No I am still searching the web to find a solution. The below website may have a solution. But I dont know much about DAX.

http://radacad.com/solving-dax-time-zone-issue-in-power-bi

[sureshsonti]

This is my data model. Today's Volume will be showing 0 after 7 PM today. 

Sch_Qty is what was ordered and Yardage is what was actually delivered

I used this statement by creating a new measure. 

Yardage = CALCULATE(SUM(YORX[Qty]),FILTER('YORX','YORX'[order_date]=TODAY()))

So after 7 PM tonight it is showing tomorrow's orders. I am hiding some fields which are customer names and addresses. 

My time zone is Central Standard Time (Baton Rouge, Louisiana)

[v-jiascu-msft]

Hi @sureshsonti,

I'm afraid I can't see from the snapshot that the measure shows tomorrow's orders.

1. Is it what you want or what it should be that "Today's Volume will be showing 0 after 7 PM today"?

2. Can you share a dummy sample of the original data? 

3. Are there any wrong numbers in your snapshot?

Best Regards,

Dale

[sureshsonti]

I am not able to attach a word file with screenshots.

My data has Order Date, and Units Produced which is Yardage. I just named it differently. But its the same field and I made a copy of the original field. Based on the Order Date power bi calculates Today's Yardage, MTD Yardage, and YTD Yardage.

On my workstation Power BI Desktop shows Today's Volume for Today till 11:59 PM and it changes to tomorrow at 12:00 AM which is what I want. But when I publish this data to Power BI Services after 7 PM on the same day the Today's Volume shows BLANK which means we didnt delivery or produce anything yet because that data is for Tomorrow. I am attaching a word document with screen shots

I will try to attach the screen shots

[v-jiascu-msft · Accepted solution]

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]

  v-jiascu-msft: Can you help me solve this. I have a DAX formula for the current year MTD. Trying to get a DAX formula for Last Year MTD of Same Month. Example Dec 2018 vs Dec 2017. Thanks

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

Thanks

[sureshsonti]

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

Thanks

[v-jiascu-msft]

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

[sureshsonti]

Hello,

How can I use this formula to compare Today vs Last Year Same Day.  I want to create 2 measures one for Today and the other for Last Year same day 

Example 12/17/2018 vs 12/17/2017

Thanks

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]

Hi,

I made a small change in the formula. I used - (Minus Sign) instead of + (Plus Sign). It worked great. Thanks for your help. Really appreaciate it.

[sureshsonti]

Let me try this and see if this works. Will email you back in the evening after 7 pm. Thanks for your help again. Really appreciate it.

[sureshsonti]

As of now I am getting today's orders value in Yardage column. I have to wait till 7 pm and see if it still shows today's values. I really hope it still shows todays values after 7 pm. Again thank you very much.