cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Bastien_O Frequent Visitor
Frequent Visitor

FIRSTDATE and filters

Hello,

I need your help because, I must take a date with three filters, and take the year of this date (here i have the 05/04/2016, so i want take the 01/01/2016). After, I have this interactive date, I want to create a new column and in this column compare the date of emission and my interactive date with a DATEDIFF, but the problem is that my interactive date is only on the rows who complete all filters.

It works when I put the date manually, but I don't want that.

Many thanks in advance for your assistance.

 

Capture1.PNGCapture2.PNGCapture3.PNG

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: FIRSTDATE and filters

@Bastien_O ,

 

Values in a calculated column are fixed. They are an immutable result for each row in the table. You'll need to create a measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bastien_O Frequent Visitor
Frequent Visitor

Re: FIRSTDATE and filters

@v-chuncz-msft 

 

Hi,

 

I think you don't understand my problem because I explain it badly.

 

I have created two measures who's called "DatePlusAncienneApprouvee" and "AnneePlusAncienneApprouvee", the first returns me the first "[Date d'émission]" with 3 filters. And the second returns the 1st January of the year from the first measure "DatePlusAncienneApprouvee".

 

Capture4.PNG

 

Capture5.PNG

 

This two measures works !

 

Capture6.PNG

 

 

 

 

 

 

 

 

 

 

 

 

And after I want two create a new calculated column, who return at each rows "OK" if "[Date d'émission]" is after the date of "AnneePlusAncienneApprouvee" (so the 01/01/2016) and if "[Date d'émission]" is before it return "KO" in the row.

 

Capture7.PNG

 

And the first problem is that calculated column uses all filters of "DatePlusAncienneApprouvee" and when the row doesn't fill the filters it's return 01/01/1900. And the second problem is even the row fill all filters it will return the 1st January of his year (if [Date d'émission] the the 12 July 2017 it will return the 01/01/2017 while he should return the 01/01/2016).

 

 

Capture3 (2)_LI.jpg

We view the first problem at the 1 of the picture and the second at the 2.

 

I hope to be clearer in explanation this time.

 

Thanks in advance for your assistance.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,977)