topic Re: FirstSortedValue of previous year in App Development

FirstSortedValue of previous year

Yi_DE — Mon, 16 Sep 2024 14:54:35 GMT

Hi Guys, i get 55 for firm A using

FirstSortedValue(measure, key_date)

while i select January 2024 and Firm A in my app.

I also want to get the 2023 value as comparison using

FirstSortedValue(measure, AddYears(key_date, -1)

. This however didn't work. Then i tried set analysis to preselect the data to analyse like

FirstSortedValue({<key_date= {">=$(=Date(AddYears(Min(key_date), -1))) <=$(=Date(AddYears(Max(key_date), -1)))"} measure, key_date)

that didn't work as well.

Following an simplified example of the data. Can someone help?

Kushal_Chawda — Mon, 16 Sep 2024 13:37:15 GMT

@Yi_DE what is expected output?

Yi_DE — Mon, 16 Sep 2024 14:53:39 GMT

Hi @Kushal_Chawda , the expected output is 100, the top line in the table.

Kushal_Chawda — Mon, 16 Sep 2024 15:54:19 GMT

@Yi_DE I don't think you need firstsorted value. You can use below set

=sum({<key_date={"$(=date(addyears(min(key_date),-1)))"}>} measure)

Yi_DE — Tue, 17 Sep 2024 07:44:14 GMT

@Kushal_Chawda This approach returns 0 as result, even though the key_date has the correct value of 01.01.2023

Yi_DE — Tue, 17 Sep 2024 08:55:04 GMT

I finally get it to work with this

{<[key_date.autoCalendar.Year]={"$(=Min(Year(key_date)) - 1)"}>} firstsortedvalue(measure, key_date)

, but i don't really understand why ...