Forum Discussion

dirkkoch's avatar
dirkkoch
Icon for Helper III rankHelper III
5 years ago

Dynamic Calculation of weekly Total

Dear all, I am currently struggling with a DAX calculation. The objective is to conduct a dynamic calculation related to weekly time intervals.   The starting point is a dynamic value showing tod...
Need Help
  • dirkkoch's avatar
    dirkkoch
    Icon for Helper III rankHelper III
    5 years ago

    amitchandak , thank you for the reply and support.

    I looked up your very helpful blog and added all missing columns to my date table as shown in your overview.

     

    But still I am missing the right approach to create the required DAX measure in detail to get the desired result as shown in the first message. 

     

    The first Total number is calculated per measure in one separate table related with the date table 

    No of engines =
    var count=CALCULATE(COUNTROWS(T050_DATA_BATCH),T050_DATA_BATCH[Abstellort Motor]="Mannheim - SGZ", T050_DATA_BATCH[Inbound Mannheim Plandatum].[Date]<=TODAY())
    return
    if(isblank(count),0 ,count)
     
    This measure results in 31 which now should be used for further calculation logic per week as mentioned in the first message. Do you mind to give the exact DAX measure to apply for this calculation. 
    Thank you again for the support! Highly appreciated.