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
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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

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