Forum Discussion
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...
you can do a summerize table, its like a group by. look the exemple below.
original tableand this is the summarize table, i group by location and date, and sum values, but you can change the fields.
LeandroDeodato Thanks for the quick response. Would I have to keep adding to the calculated measure every month as new data gets added? Is there a way for that to be done automatically?
- LeandroDeodato
Resolver II
you can do a summerize table, its like a group by. look the exemple below.
original tableand this is the summarize table, i group by location and date, and sum values, but you can change the fields.