Forum Discussion
imranamikhan
Helper V
5 years agoReturn value from column based on today's date
Hi everyone, Background/Context: I have the following sample table: Date Series: a column which contains an iterative list of week ending dates. Baseline: for each row, count th...
- 5 years ago
Try this if you want to filter Sunday:
CalculatedBaseline = CALCULATE ( SUM ( Table[Baseline] ), FILTER ( ALL ( Table ), Table[Date Series] = TODAY () + 7 - WEEKDAY ( TODAY (), 2 ) ) )For Saturday:
CalculatedBaseline = CALCULATE ( SUM ( Table[Baseline] ), FILTER ( ALL ( Table ), Table[Date Series] = TODAY () + 7 - WEEKDAY ( TODAY (), 1 ) ) )
imranamikhan
Helper V
5 years agoThank you!
- Mohammad_Refaei5 years ago
Solution Specialist
My pleasure