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.
Super UserHi,
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!!
- Ashish_MathurYou are welcome. I do not understand your second requirement.