Forum Discussion
andrei_iuganu
9 years agoRegular Visitor
calculate and Filtering help - powerbi desktop
Hi all.
I need some help.
Vanessafvg had goodwill and guided my beginner's steps in powerbi.
In the file here https://www.dropbox.com/s/1ga9ace3tnst03u/work.pbix?dl=0 I want what is calculated / displayed in the Report to be made taking into account the month and code_item. For this I created a "Final stock" measure in the End code_item table.
I'm a beginner and I think there's something else to be added to the formula so that each code is shown only one with the total but every month.
For example: For product with code_item 1 A0612 - all values in month number 1 to be added, then in month number 2, up to month number 12 (inclusive).
1 Reply
- v-chuncz-msft
Community Support
You may try to use SUMMARIZE Function or GROUPBY Function to create a calculated table.