Forum Discussion
felipetrin
6 years agoRegular Visitor
Running count total by month (IMPOSSIBLE?)
Hello everyone! To summarize my infos: WHAT I HAVE: A database that shows when (DATE) a new machine (MACHINE) was added in my mini factoty and its level of importance (LEVEL OF IMPORTANCE) [Chec...
stevedep
Memorable Member
6 years agoHi,
The code below should do the trick.
_RT =
var _no = CALCULATE(DISTINCTCOUNT(NewTable[i]), ALL(NewTable[i]))
return
COUNTROWS(FILTER(ALL(NewTable), NewTable[imp] = SELECTEDVALUE(NewTable[i]) && [date] <= MAX(NewTable[date]))) / _no
It does require you to transform your table / add a new version of it:
NewTable = CROSSJOIN(SELECTCOLUMNS(VALUES('Table'[imp]),"i", [imp]),'Table')
In this video I show how to create the dashboard as seen below.
Link to the file here.
Pls mark as solution if so. Thumbs up for the effort are appreciated.
Kind regards,
Steve.