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 visual