Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
andrei_iuganu
Regular 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 1
v-chuncz-msft
Community Support
Community Support

@andrei_iuganu,

 

You may try to use SUMMARIZE Function or GROUPBY Function to create a calculated table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.