Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dax Formula for 3 different measure trailing 12 months
05-30-2023
10:26 AM
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
Top Solution Authors (Last Month)
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |