Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

It will become easier to solve the problem if you have lower and upper limit columns in your frequency table (so there should be 3 instead of 2 columns that you currenly have).  Please make that change and share the link from where i can download your PBI file.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello!!

 

Thanks for the help in advance! I tried to do what you say Anonymous. Buy it didn't work. The field is in blank:

 

Ashish_MathurI've uploaded the file in: https://files.fm/u/y6cnygt5

 

Thanks!