Forum Discussion
Taking Data from another table (Without relathions)
Hello, I want to take a score fron another table without relathionships. In fact, I want that in the Score Column in the Dataset table take the data from Frecuecy depending the number in "Día...
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!!
Ashish_Mathur
Super User
Super UserYou are welcome. I do not understand your second requirement.