Forum Discussion

dhslxop's avatar
dhslxop
Frequent Visitor
2 years ago
Solved

Looking Up Correct Value

Hello! I am hoping for some assistance with this because I'm not really sure where to start. I have several tables that come from excel that I am trying to use in PowerBI. In PowerBI I have 3 slicers...
Need Help
  • LeandroDeodato's avatar
    LeandroDeodato
    2 years ago

    you can do a summerize table, its like a group by. look the exemple below.

    original table

    and this is the summarize table, i group by location and date, and sum values, but you can change the fields.

     

LeandroDeodato's avatar
LeandroDeodato
Icon for Resolver II rankResolver II
2 years ago

you need change you table like below, and use a calculate mensure to sum location 1, location 2, category a, category b, etc...