Reply
savimarie
New Member

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 visual 
0 REPLIES 0
avatar user

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.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)