Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone, how to hide the future dates for my cumulative measure? I wanted to hide the future date base on the current filter.
Here's the measure:
Total Sales by Department YTD =
CALCULATE (
[Invoiced amount time + total costs],
FILTER (
ALL ( 'Date' ),
'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] )
), 'Date'[Date] <= TODAY()
)
Solved! Go to Solution.
@ronaldbalza2023 , Try
Total Sales by Department YTD =
CALCULATE (
[Invoiced amount time + total costs],
FILTER (
ALL ( 'Date' ),
'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] ) && 'Date'[Date] <= TODAY()
)
)
or
Total Sales by Department YTD =
if( max('Date'[Date] <= TODAY()), CALCULATE (
[Invoiced amount time + total costs],
FILTER (
ALL ( 'Date' ),
'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] )
)
), blank())
@ronaldbalza2023 , Try
Total Sales by Department YTD =
CALCULATE (
[Invoiced amount time + total costs],
FILTER (
ALL ( 'Date' ),
'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] ) && 'Date'[Date] <= TODAY()
)
)
or
Total Sales by Department YTD =
if( max('Date'[Date] <= TODAY()), CALCULATE (
[Invoiced amount time + total costs],
FILTER (
ALL ( 'Date' ),
'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] )
)
), blank())
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |