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) [Check out the picture in the end of this post]. WHAT I WANT: I want to check out the evolution of my machines in my mini factory detailing it by level of importance according when they were bought (DATE) [Check out the picture in the end of this post]. WHAT I'VE TRIED: I've tried this DAX Measure: Measure = CALCULATE( COUNTROWS(Table), FILTER( ALL(Table), Table[Date] <= MAX(Table[Date]) ) ) PICTURE: Thanks for helping me!
