https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-previous-days-values/m-p/3824117#M149550 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="666202" data-lia-user-login="LFM" class="lia-mention lia-mention-user">LFM</a>&nbsp;You are using CALCULATE and TI functions is what is primarily wrong. Do this instead:</P> <LI-CODE lang="markup">Measure = VAR __Date = MAX('NPOSC'[date]) - 1 VAR __Table = FILTER( ALL('NPOSC'), [date] = __Date ) VAR __Result = SUMX( __Table, [exposure_mwh] ) RETURN __Result</LI-CODE> Tue, 09 Apr 2024 15:02:02 GMT Greg_Deckler 2024-04-09T15:02:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-previous-days-values/m-p/3824102#M149546 <P>Im trying to calculate previous days exposure for the measure called "prevous days exposure_mwh". It should be the sum of exposure for the last day. I dont get any values as seen in the pictures. What is wrong wilth the calculation?<BR /><BR /><img /><img /><img /></P> Tue, 09 Apr 2024 14:53:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-previous-days-values/m-p/3824102#M149546 LFM 2024-04-09T14:53:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-previous-days-values/m-p/3824117#M149550 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="666202" data-lia-user-login="LFM" class="lia-mention lia-mention-user">LFM</a>&nbsp;You are using CALCULATE and TI functions is what is primarily wrong. Do this instead:</P> <LI-CODE lang="markup">Measure = VAR __Date = MAX('NPOSC'[date]) - 1 VAR __Table = FILTER( ALL('NPOSC'), [date] = __Date ) VAR __Result = SUMX( __Table, [exposure_mwh] ) RETURN __Result</LI-CODE> Tue, 09 Apr 2024 15:02:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-previous-days-values/m-p/3824117#M149550 Greg_Deckler 2024-04-09T15:02:02Z