Forum Discussion

dqG9kYbAmF7tfNx's avatar
dqG9kYbAmF7tfNx
Frequent Visitor
7 years ago
Solved

daily production

can you please help me create a dax for calculating the sum of the daily production where my day starts at 5:00 am, and ends at 5:00am next day. also ny weekly production starts 5:00 am Sunday to 5:00 am sunday of the next week.

in other words, my day starts at 5:00 am not 12:00 am

Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi dqG9kYbAmF7tfNx, 

     

    You can create two calculated columns like below: 

     

    NewDateTime = Table1[DateTime]-5/24
    NewDate = Table1[NewDateTime].[Date]

     

    Then create a measure: 

     

    Measure 4 = CALCULATE(SUM(Table1[Amount]),FILTER(ALL('Table1'),Table1[NewDate]=MAX(Table1[NewDate])))
     
     
    Best Regards,
    Qiuyun Yu 

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi dqG9kYbAmF7tfNx, 

     

    You can create two calculated columns like below: 

     

    NewDateTime = Table1[DateTime]-5/24
    NewDate = Table1[NewDateTime].[Date]

     

    Then create a measure: 

     

    Measure 4 = CALCULATE(SUM(Table1[Amount]),FILTER(ALL('Table1'),Table1[NewDate]=MAX(Table1[NewDate])))
     
     
    Best Regards,
    Qiuyun Yu 
    • dqG9kYbAmF7tfNx's avatar
      dqG9kYbAmF7tfNx
      Frequent Visitor
      7 years ago

      Thank you, this is amazing. I still don't know much how it works