Forum Discussion
gmasta1129
Resolver I
Resolver IPrevious Day Function (Weekends excluded)
Hello, I have data for Monday to Friday only. I am using the formula below to compare the previous day minus today's values. My issue is with Monday's calculation showing that there is a di...
gmasta1129
You can use the following measure to get the desired results.Difference = VAR __CurrentDate = MAX ( 'daily_report'[date time] ) VAR _LastDate = LASTDATE ( FILTER ( ALL ( 'daily_report'[date time] ), 'daily_report'[date time] < __CurrentDate && NOT WEEKDAY ( 'daily_report'[date time], 2 ) IN { 6, 7 } ) ) VAR __Result = CALCULATE ( SUM ( daily_report[total value usd] ), _LastDate ) RETURN __ResultHello,
It worked! i just made a small change to the VAR Result portion of the formula you sent.
Thank you so much for your help!!! I was working on it for hours to try and figure it out before i went to this website.
Fowmy
Super User
Super Usergmasta1129
You can use the following measure to get the desired results.
Difference =
VAR __CurrentDate =
MAX ( 'daily_report'[date time] )
VAR _LastDate =
LASTDATE (
FILTER (
ALL ( 'daily_report'[date time] ),
'daily_report'[date time] < __CurrentDate
&& NOT WEEKDAY ( 'daily_report'[date time], 2 ) IN { 6, 7 }
)
)
VAR __Result =
CALCULATE ( SUM ( daily_report[total value usd] ), _LastDate )
RETURN
__Result
gmasta1129Hello,
It worked! i just made a small change to the VAR Result portion of the formula you sent.
Thank you so much for your help!!! I was working on it for hours to try and figure it out before i went to this website.