Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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,

 

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

Sample data and expected output will be helpful to provide an accurate solution.Could you upload the .pbix file to OneDrive and post the link here? Do mask sensitive data before uploading.

Regards,