Forum Discussion
Taking Data from another table (Without relathions)
Hi,
Try this calculated column formula
=CALCULATE(MIN('Frequency Lower'[F.Puntaje]),FILTER('Frequency Lower','Frequency Lower'[Frecuency Lower]<=EARLIER([Dias Transcurridos])&&'Frequency Lower'[Frecuency Upper]>=EARLIER([Dias Transcurridos])))
As of now, nothing is returned because the lower and upper limit numbers in the frequency lower table are far below those in the Dias Transcurridos column.
Done It! Link: https://files.fm/u/dtwr8sua
Thanks!
Hi,
Try this calculated column formula
=CALCULATE(MIN('Frequency Lower'[F.Puntaje]),FILTER('Frequency Lower','Frequency Lower'[Frecuency Lower]<=EARLIER([Dias Transcurridos])&&'Frequency Lower'[Frecuency Upper]>=EARLIER([Dias Transcurridos])))
As of now, nothing is returned because the lower and upper limit numbers in the frequency lower table are far below those in the Dias Transcurridos column.
Oh!! It's Works.
I've to change the field because it's not the table where i've to do the calculations. Thanks to your comment i noticed that (Thank!!)
The last thing I don't solve is how to match the number (One column have one more unit)
My Screenshot
My File: https://files.fm/u/zyvsew3g
But! Thanks! The last question solve my issue. Thanks!!
- You are welcome. I do not understand your second requirement.