Forum Discussion

qwaiti27231's avatar
qwaiti27231
Icon for Helper III rankHelper III
9 years ago
Solved

week on week

i need the dax formula for week on week   for eg    count of order Id with 10/9/2017- count of order with 3/9/2017)/count Of order in 3/9/2017 For eg  count of order at 3/9/2017= 32 count of or...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    qwaiti27231

     

    You can create a measure like below:

     

    7 days ago value = CALCULATE(SUM(Table5[Value]),FILTER(ALL(Table5),Table5[Date]=MAX(Table5[Date])-7))

     

     

    Regards,

    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      qwaiti27231

       

      You can create a measure like below:

       

      7 days ago value = CALCULATE(SUM(Table5[Value]),FILTER(ALL(Table5),Table5[Date]=MAX(Table5[Date])-7))

       

       

      Regards,

      • qwaiti27231's avatar
        qwaiti27231
        Icon for Helper III rankHelper III
        8 years ago

        v-sihou-msft is there any way i can contact  you...Requesting  ur help in many other queries....just joined as BI developer..would appreciate ur help