topic How to bring a fixed value from a date based data source to a line based on a different date in App Development

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

Ishragil — Mon, 20 Dec 2021 21:08:46 GMT

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

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

Or — Tue, 02 Jun 2020 11:40:09 GMT

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

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

Ishragil — Wed, 03 Jun 2020 06:16:30 GMT

Great
Thanks a lot