Forum Discussion

WaelTalaat79's avatar
WaelTalaat79
Icon for Helper I rankHelper I
2 years ago
Solved

Calculate value in coulamn based on Max week Number

Dears

thanks for your support in advance

i have this DAX fromula to calculate the stock value in coulmn based on another coulmn slicer range week number
Ex. the slicer from Week 10 to week 17

i need to sum the week 17 stock value to compare with the week 10 stock value

Stock Value Max =
VAR week_Max = MAX('EOL Follow up'[Week #])
return
CALCULATE(SUM('EOL Follow up'[TOTAL CP VALUE]),SELECTEDVALUE('EOL Follow up'[Week #])=week_Max)
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi WaelTalaat79 

     

    Thanks for the reply from Ritaf1983 .

     

    WaelTalaat79 , you can try the following method as follows.

     

    My sample:

     

    1. Create a calculated table as the slicer

    Slicer = VALUES('Table'[weeknum])

     

     

    2. Create a measure as follows

    Measure = 
VAR _max = CALCULATE(SUM('Table'[Value]), FILTER('Table', [weeknum] = MAX('Slicer'[weeknum])))
VAR _min = CALCULATE(SUM('Table'[Value]), FILTER('Table', [weeknum] = MIN('Slicer'[weeknum])))
RETURN
_max - _min

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • WaelTalaat79's avatar
    WaelTalaat79
    Icon for Helper I rankHelper I
    2 years ago

    Ritaf1983 i can't to upload the pbix but here below screen shot

    the total stock value in week 13 and here if i select from 10 to 13 the idea is to show the value of the Max week numbwer which is 13  to compare with ninmum week numbwer which is 10

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi WaelTalaat79 

       

      Thanks for the reply from Ritaf1983 .

       

      WaelTalaat79 , you can try the following method as follows.

       

      My sample:

       

      1. Create a calculated table as the slicer

      Slicer = VALUES('Table'[weeknum])

       

       

      2. Create a measure as follows

      Measure = 
VAR _max = CALCULATE(SUM('Table'[Value]), FILTER('Table', [weeknum] = MAX('Slicer'[weeknum])))
VAR _min = CALCULATE(SUM('Table'[Value]), FILTER('Table', [weeknum] = MIN('Slicer'[weeknum])))
RETURN
_max - _min

       

      Output:

       

      Best Regards,
      Yulia Xu

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.