Distinct last year from a date column

[Anonymous]

Hi Team,

I need distinct current year-1 from a date column based on the dropdown selected for client.

Date	Client
1/1/2020	ABC
1/1/2020	ABC
1/1/2020	ABC
1/1/2020	ABC
1/1/2020	ABC
1/1/2020	ABC
1/1/2020	ABC
2/1/2020	BCD
2/1/2020	BCD
2/1/2020	BCD
2/1/2020	BCD
2/1/2020	BCD
2/1/2020	BCD
2/1/2020	BCD

[eka24]

Consider this:

Distinct(Datasource,Text(Date,"yyyy"))

Or

Distinct(Datasource,Text(DateValue(Date),"yyyy"))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

[Anonymous]

@eka24 

I want current year-1.That means 2021-1 =2020 from the date column based on the client selected from dropdown from client column.

[eka24]

Please show a screen shot of the current formula on the Items of the Dropdown

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Anonymous]

@eka24 .

This is the formula I am using now as dropdown, which allows user to select the year.

Distinct(Filter(SOC_Assessment_Responses,Client_Name = Dropdown1.Selected.Result),Year(Date)).Result

But I want to hardcode it to current year-1.

[eka24 · Accepted solution]

Try this:

Distinct(Filter(SOC_Assessment_Responses,Client_Name = Dropdown1.Selected.Result),Text(Date,"yyyy-m")).Result

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.