Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |