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.
Anonymous Looks like a good case for using static segmentation - check out Marco's write up on this here