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.
In DAX, the general measure pattern is as follows
Inventory :=
CALCULATE (SUM ( Inventory[StockCount] ),
LASTNONBLANK (Calendar[Date],CALCULATE ( SUM ( Inventory[StockCount] ) )))
this is pattern will work regardless of there being a count for every date (it will find the last count).
It will be possible but you will need to add a calculated measure to your cube. Are you using Tabular or Multidimensional? Both will work but one will use DAX while the other will need an MDX formula.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |