Forum Discussion

Spotto's avatar
Spotto
Icon for Helper IV rankHelper IV
4 years ago

Get the Same or Previous Date- Help

Hello everyone, I have a TABLE A where I have a date, I need to get the TRAVA field of TABLE B with the date equal to or before the date of table A I am not able to find a solution for this.     ...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Spotto ,

 

Please try:

Create a measure:

Measure = MAXX(FILTER('TABLE B',[CONTRATO]=MAX('TABLE A'[CONTRATO])&&[DATA]<=MAX('TABLE A'[DATA])),[TRAVA])

Then Apply it to the visual

Output:

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Spotto's avatar
    Spotto
    Icon for Helper IV rankHelper IV
    4 years ago

    thanks for the help but I needed to return the same date or before the date. In the example contract 222b has the date jan/05, the same or earlier date would be jan/03 and the result would be F