cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leudyston Regular Visitor
Regular Visitor

Create Measure Stock Balance

Hello my friends, I'm breaking my head with this measure, I need to calculate the stock balance(SALDO), grouping by store(idiloja), product(iditem) and date mov(iddata_movimento). In database, I got sucess with this consult. How do I create this measure in DAX?database

In attachment i have make a test pbix file.

File PBIX



Thanks

print.jpg

 

Leudyston

2 ACCEPTED SOLUTIONS

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: Create Measure Stock Balance

Hi @leudyston

 

I think I know what you are after but not sure.  Is this close as a calculated measure?

 

Running Balance = CALCULATE(
				SUM('fmovimentos'[mov_estoque])
				,FILTER(
					ALL('fmovimentos'),
					'fmovimentos'[idloja] = MAX('fmovimentos'[idloja])
					 && 'fmovimentos'[iditem] = MAX('fmovimentos'[iditem])
					 && 'fmovimentos'[iddata_movimento] <= MAX('fmovimentos'[iddata_movimento])
					)
				)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

v-yulgu-msft Super Contributor
Super Contributor

Re: Create Measure Stock Balance

Hi @leudyston,

 

Have you achieved your desired result with Phil_Seamark's suggestion? If yes, would you please accept his reply as a solution so that others can find the answer more easily? 

 

"I need to simulate this image report, in a PivotTable in PivotTable. I found that getting to the BALANCE by product would be able to use the same measure for other contexts. Can you help me?" I'm not clear about this requirement. Is it related to the original one? If yes, please provide more description about it so that I can test for you. If it is a new request, please post your question as a new thread so that more community members can view it.

 

By the way, to help us better understand your table structure and protect your sensitive data, please simplify your sample data posted here.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
leudyston Regular Visitor
Regular Visitor

Create Measure Stock Balance

https://mega.nz/#!QY1lXDoQ!8-c8qyvgNYa7HVzxdV---3-MQQOpyKchieMGHGe-CLk

 

Hello my friends, I'm breaking my head with this measure, I need to calculate the stock balance(SALDO), grouping by store(idiloja), product(iditem) and date mov(iddata_movimento). In database, I got sucess with this consult. How do I create this measure in DAX?database

 

In attachment i have make a test pbix file.

 

Thanks

Leudyston



Phil_Seamark Super Contributor
Super Contributor

Re: Create Measure Stock Balance

Hi @leudyston

 

I think I know what you are after but not sure.  Is this close as a calculated measure?

 

Running Balance = CALCULATE(
				SUM('fmovimentos'[mov_estoque])
				,FILTER(
					ALL('fmovimentos'),
					'fmovimentos'[idloja] = MAX('fmovimentos'[idloja])
					 && 'fmovimentos'[iditem] = MAX('fmovimentos'[iditem])
					 && 'fmovimentos'[iddata_movimento] <= MAX('fmovimentos'[iddata_movimento])
					)
				)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

leudyston Regular Visitor
Regular Visitor

Re: Create Measure Stock Balance

Hello Phil, thank you for your attention !!

 

This workaround works when I do not use filters in context. When I use the filters, the result changes and takes a long time to appear. I need to simulate this image report, in a PivotTable in PivotTable. I found that getting to the BALANCE by product would be able to use the same measure for other contexts. Can you help me?

 

REPORT.png

 

pbi.jpg

 

 

 

v-yulgu-msft Super Contributor
Super Contributor

Re: Create Measure Stock Balance

Hi @leudyston,

 

Have you achieved your desired result with Phil_Seamark's suggestion? If yes, would you please accept his reply as a solution so that others can find the answer more easily? 

 

"I need to simulate this image report, in a PivotTable in PivotTable. I found that getting to the BALANCE by product would be able to use the same measure for other contexts. Can you help me?" I'm not clear about this requirement. Is it related to the original one? If yes, please provide more description about it so that I can test for you. If it is a new request, please post your question as a new thread so that more community members can view it.

 

By the way, to help us better understand your table structure and protect your sensitive data, please simplify your sample data posted here.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
leudyston Regular Visitor
Regular Visitor

Re: Create Measure Stock Balance

Okay, I will create a new thread 

 

Thanks.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 301 members 3,403 guests
Please welcome our newest community members: