Forum Discussion

gcrespo's avatar
gcrespo
Helper I
2 years ago
Solved

Zero-To-Date calculation

Hi everyone, I'm trying to get the total number of rows from the beginning of time up to every month. Much like a YTD calculation but not resetting every year. So far, the best I've managed to get i...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

gcrespo 

As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel

 

Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist

 

After date dimension is added , measure will look something like this:

 

All Time RT = 
CALCULATE ( 
   DISTINCTCOUNT ( Table[Column] ),
   FILTER ( 
      ALL ( DateTable[Date] ),
      DateTable[Date] <= MAX ( DateTable[Date] )
   ),
   <<your containsstring expression here>>
)