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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |