Forum Discussion
Value for specific date
Is it possible to get a value for an specific date. It might me important to clarify that the value es calculatet by the difference of two measures that were already created? for example I need yes...
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
Based on your page level filter.You may create a measure as below to get yesterday's [Measure 4].
Measure = IF ( MAX ( 'Table'[Day] ) = DAY ( TODAY () ) - 1, [Measure 4] )
Regards,
It gives me a (BLANK) card. I used the same measure you wrote
v-cherch-msft wrote:Hi Anonymous
Based on your page level filter.You may create a measure as below to get yesterday's [Measure 4].
Measure = IF ( MAX ( 'Table'[Day] ) = DAY ( TODAY () ) - 1, [Measure 4] )Regards,
v-cherch-msft wrote:Hi Anonymous
Based on your page level filter.You may create a measure as below to get yesterday's [Measure 4].
Measure = IF ( MAX ( 'Table'[Day] ) = DAY ( TODAY () ) - 1, [Measure 4] )Regards,
v-cherch-msft wrote:Hi Anonymous
Based on your page level filter.You may create a measure as below to get yesterday's [Measure 4].
Measure = IF ( MAX ( 'Table'[Day] ) = DAY ( TODAY () ) - 1, [Measure 4] )Regards,