Forum Discussion

mikayla's avatar
mikayla
Frequent Visitor
5 years ago
Solved

Dynamic Pre/Post Calculation

I'm trying to dynamically calculate for pre/post sales based on an index slicer selection. My dataset looks as follows:   Index Timing TY Sales LY Sales -4 Pre 473891 263538 -3 Pre ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi mikayla ,


    You could create a measure by the following formulaļ¼š

    value =
VAR _presum =
    SUMX ( FILTER ( 'Table', [Timing] = "Pre" ), [TY Sales] )
RETURN
    DIVIDE (
        SUMX ( FILTER ( 'Table', [Timing] = "Post" ), [TY Sales] ) - _presum,
        _presum
    )

    The final output is shown below: When the choice of slicer is different(Use Ctrl to select multiple options), the value is also different

     

     


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

MURTAZA's avatar
MURTAZA
Resolver I
5 years ago

mikaylaYour problem is not clear. Can you elaborate?

Do you want help in writing this measure/calculated column or creating a slicer with ranges?

  • mikayla's avatar
    mikayla
    Frequent Visitor
    5 years ago

    Of course, let me elaborate. I've already created the slicer with the index range but I am struggling with writing the measure/calculated column as I am fairly new to DAX. Any help is so appreciated! Let me know if I am still not being clear.