Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 yesterdays value only, cause I need to use it for a multiplication to crreate another measure
thankss
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,
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |