Tuesday, August 25, 2020

Total Sales All Time (remove blanks)

 Total Sales (All Time) =

IF(
[Total Sales] = BLANK(),
BLANK(),
CALCULATE(
[Total Sales],
ALL('Date'[CalendarYear] ) ) )

No comments:

Post a Comment