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
Announcements
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
User | Count |
---|---|
9 | |
9 | |
6 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
7 |