Forum Discussion

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
2 years ago
Solved

calculating specific months

Hello, i need to calculate the values from the current month in a metric, and also need to have to sum values of the previous 6 months. having the filter, im doing the following below to calculated...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jppuam ,

     

    My workaround changes dynamically based on the top value of the slicer, you can try it.

     

    Best Regards,

    Stephen Tao

     

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

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi jppuam ,

 

Since you are using the ALLSELECTED the calculation is getting only the filtered values for this you need to use the ALL statement to get the full information and then apply the filter to the selected time frame.

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
2 years ago

Hello Miguel,

i've tested with ALL, and its not working.

thansk for the respose.

JR