Forum Discussion

olividd's avatar
olividd
Regular Visitor
7 years ago
Solved

Power pivot output with overlapping periods

Hi, I have a dataset containing monthly transaction data broken down by transaction type which could take on any value from Transaction A, B, C ... X.     In a separate table I have defin...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi olividd,

    Acccording to your description, you could create measures for each column like below to achieve this goal

    16/17 = CALCULATE(SUM(T1[value]), FILTER(ALLEXCEPT(T1,T1[Transaction tytpe]), RELATED(t2[fy])="16/17"))
ltm 17 = CALCULATE(SUM(T1[value]), FILTER(ALLEXCEPT(T1,T1[Transaction tytpe]), RELATED(t2[ltm])="ltm 17"))

    You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

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

     

dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

Hi olividd,

Acccording to your description, you could create measures for each column like below to achieve this goal

16/17 = CALCULATE(SUM(T1[value]), FILTER(ALLEXCEPT(T1,T1[Transaction tytpe]), RELATED(t2[fy])="16/17"))
ltm 17 = CALCULATE(SUM(T1[value]), FILTER(ALLEXCEPT(T1,T1[Transaction tytpe]), RELATED(t2[ltm])="ltm 17"))

You could refer to my sample for details.

Best Regards,
Zoe Zhi

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