Answered

Distinct last year from a date column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No