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:0...
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 
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