Forum Discussion

coliveira77's avatar
coliveira77
Frequent Visitor
5 years ago
Solved

The Date table does not relate to another date table

Hello friends from Power Bi, For a week now I have been researching how to include a new table of interest rates and access according to the period of each line. Link to the PBIX files     ...
Need Help
Tutorial Requests
  • coliveira77's avatar
    coliveira77
    5 years ago

    Hello Friend DataInsights thanks for the help, I was able with this formala see the value of the adjustment, then I make another measurement for the final value.

     

    1 Valor Reajuste =
    CALCULATE (
    LASTNONBLANKVALUE (fReajustes[adjustment date] , [sum_reajustes]),
    FILTER (
    ALL ( dCalendar[Date]),
    dCalendar[Date] <= MAX ( dbo[measure_date]
    )
    ))
coliveira77's avatar
coliveira77
Frequent Visitor
5 years ago

Thanks for the help DataInsights, but when I apply it to my file, it comes up with another value, I did some variations without success.

 

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

coliveira77,

 

Try breaking it down so you can see each component of the calculation. After RETURN in the measure, put vRate instead of vResult. This will display the rate being used. Do the same with each variable to identify the problem.

  • coliveira77's avatar
    coliveira77
    Frequent Visitor
    5 years ago

    Hello Friend DataInsights thanks for the help, I was able with this formala see the value of the adjustment, then I make another measurement for the final value.

     

    1 Valor Reajuste =
    CALCULATE (
    LASTNONBLANKVALUE (fReajustes[adjustment date] , [sum_reajustes]),
    FILTER (
    ALL ( dCalendar[Date]),
    dCalendar[Date] <= MAX ( dbo[measure_date]
    )
    ))