Forum Discussion

trsh3r's avatar
trsh3r
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...
Need Help
  • trsh3r's avatar
    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])
    )
)

      

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

trsh3r's avatar
trsh3r
Frequent Visitor
3 years ago

Thank you for your tips. The PowerBI desktop file is included at the end of my post