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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Calculating Inventory Value- Power BI Help

Hi All,

 

I require some asssitance in perfomring a task using DAX for Power BI. Inventory system is Microsft Dynmaincs 365 BC. 

 

Power BI creating of a dashboard of inventory value and QTY over time. 

 

This would equate to highligting the per month inventory value and qty and then being able to select the month previously and view the type of items which inventory was held. 

 

Using table via item ledger for qty and value entry for value, however im stuck in attempting to show the monhtly value previously using the value table as each month is a total of postivies and negatives but when using DAX measures im unable to group the value of cost of inventory by month.

 

Any guidance would be greatly appreciated. 

 

regards

 

1 REPLY 1
lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.