Dax Formula for 3 different measure trailing 12 months
I'm trying to get a visual for 12 months trailing with 3 different calculated measures from my GL for day saels inventory. my first measure (cogs) is a 3 month average of multiple accounts 3 month average = CALCULATE(SUM(Ledger_mst[Debit Account]),OR(Ledger_mst[Month]=1,OR(Ledger_mst[Month]=2,Ledger_mst[Month]=3)),Ledger_mst[Acct] IN {"51000","56500","56525","57300","57310","57400","58500","64400","64420"},Ledger_mst[Year]=2023)/3 second measure is (inventory) of multiple accounts Selected Account Debit (DSI) = CALCULATE(SUM(Ledger_mst[Debit Account]), Ledger_mst[Account Description] IN {"Finished Goods labor","Finished Goods material","Finished Goods Overhead","Raw material","WIP labor","WIP material","WIP overhead"}) final measure for DSI is DSI = ([Selected Account Debit (DSI)]/[3 month average])*(365/12) I can not figure out how to take these measure and apply them to achieve a co-hesive 12 month trailing visualPerpetual Average Cost Inventory Method - Help Needed to Keep the Correct Average Inventory Price
Hi there! I am trying to calculate my inventory totals using Perpetual AVCO method (https://xplaind.com/840515/avco-method). Everything is okay except one thing: I can not figure out how to keep the right Weighted Unit Cost price that would disregard any SALE transactions. Down below please see attached the working files for more understanding. XLS File PBIX If you look carefully at the Excel file, you will see the *NEW* average inventory price after the new purchase at higher price. I basically need Power BI to automatically calculate that price and use it every time there is "BUY" in the "Buy/Sell" column. Thanks in advance!
Rolling total where data rows are sporadic
Hi! I have a Trial balance that provides the following output: The Entry for March 2019 for "Deposits" should be 9,897.50 but, since there were no transactions in that month for that account, the balance isn't calculated/presented. The Measure I'm using is otherwise fine, and pretty standard: =calculate(Sum(Data[Amount]),FILTER(all('Calendar'[Date]),'Calendar'[Date] <=max(Data[Date]))) How can I modify this so that the balance for a period shows, even if there are no transactions in that period? Thanks!
