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.

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Bastien_O ,

Could you please offer your pbix file to have a test if possible, you could upload it in OneDrive and send the link here.

Also you could try to use a calculated measure instead of calculated column.

 

Regards,

Daniel He

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.