Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
avg({1<[Date Diff] = {0}>} total [MonthlyAccomulatingWorkingDays])
Great
Thanks a lot