Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors