Forum Discussion

Frequent Visitor

3 years ago

Solved

Cannot manage to create the proper pivot table

Good day all! I've been tinkering with this one for a while but cannot seem to get the expected result, so thought I'd reach out. Quick context: I have a table (below) listing for each team mem...

trsh3r
3 years ago
if anyone needs it, I found my own answer: a simple measure calculated with SUMX, created for each period.
SumP0 = SUMX ( VALUES ('TRANSFORMED DATA'[Name]), CALCULATE ( SUM ('TRANSFORMED DATA'[NBD P0]) ) )

Frequent Visitor

3 years ago

if anyone needs it, I found my own answer: a simple measure calculated with SUMX, created for each period.

SumP0 = 
SUMX (
    VALUES ('TRANSFORMED DATA'[Name]), 
    CALCULATE (
        SUM ('TRANSFORMED DATA'[NBD P0])
    )
)