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 |
Solved! Go to 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.
Consider this:
I want current year-1.That means 2021-1 =2020 from the date column based on the client selected from dropdown from client column.
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.
@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.
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.