How to bring a fixed value from a date based data source to a line based on a different date

[Ishragil]

I guess my formar question was not clear so I will elaborate:

I have a data source that is loaded to the BI:

I want the value that matched to todays date to appear in the following column, regardless the date appear in the line, meaning that I would like the value of today (2) to appear even if the date on the line is yesterday (and tomorrow I would like the value 3 to apear in all lines)

I tried the following:  avg({1<[Date Diff] = {0}>} [MonthlyAccomulatingWorkingDays]) , but as you can see it shows me the correct value only in the total line.

Thanks in advance for your assistance

Amir

 

[Or]

avg({1<[Date Diff] = {0}>} total [MonthlyAccomulatingWorkingDays])

[Ishragil]

Great
Thanks a lot