Forum Discussion

Bastien_O's avatar
Bastien_O
Frequent Visitor
7 years ago
Solved

Calculated column with filter on a measure

Hello, 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 return...
Need Help
  • Bastien_O's avatar
    Bastien_O
    7 years ago

    Hello everyone, 

     

    I have just found the solution of my problem !

     

    Before I have created a measure to find the first date who complete my filters.

    I take it and I create a new table who returns all the date between the 1st January of the year of my first date and today. 

    I have created a relation between the new column and the date of all data.

     

    And after I edit my calculated column.

    And finally, my calculated column works perfectly.

     

Bastien_O's avatar
Bastien_O
Frequent Visitor
7 years ago

Hi v-danhe-msft 

I can do an array for illustrate and if it help you !

 

Hope I help you ! 

Regards, 

Bastien

Bastien_O's avatar
Bastien_O
Frequent Visitor
7 years ago

Hello everyone, 

 

I have just found the solution of my problem !

 

Before I have created a measure to find the first date who complete my filters.

I take it and I create a new table who returns all the date between the 1st January of the year of my first date and today. 

I have created a relation between the new column and the date of all data.

 

And after I edit my calculated column.

And finally, my calculated column works perfectly.