Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello experts,
I have 3 data tables: list of items (dim), inventory in warehouses (fact) and inventory transactions in warehouses (fact).
The 2 "fact" tables are linked in model to the "dim" table through "item number".
I need to set a measure that will display: (quantity in warehouses) / (summary of transactions in last 30 days).
Here are the measures I have now, bu results of Qty. WH/Trans. 30 days are not correct:
Qty. WH = SUM(fctWHINventory[WHQty.])
Thanks, I appreciate your help, but this is not what I need.
I need a measure that gives me value for: (Sum[Qty.-in-Stock])/(Sum(Transactions[TransQty.] in last 30 days) for each Item-No.
@RafaelAri , Try with help from
Rolling 30 = CALCULATE(Sum(fctStockTransactions[TransQty.]) ,DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-30,DAY))
Rolling 30 = CALCULATE(Sum(fctStockTransactions[TransQty.]) , WINDOW(-29,REL, 0, REL, ADDCOLUMNS(ALLSELECTED('Date'[Date] ),ORDERBY([Date],asc)))
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |