Forum Discussion
Solved
DAX Measure
I have a senario in Power BI that I can't seem to figure out. I have a table with various loan data, i.e. interest rate, UPB, DTI, etc. I also have a column with historical price these loans sold a...
Hi azale2407 ,
see my new pbi file. I have created a new table and a new slicer for Loan Number that is not going to affect the calculation of the variable Z.
https://1drv.ms/u/s!Aj45jbu0mDVJi3BPJZwKA7Yqf21J?e=Je4U6u
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is an example....
- I need to create a measure to show Yield where:
(X * Y) / (X * Z) = Yield
- Z is dynamically changing as the three red bordered slicers are adjuested
- X and Y are exact values of the loan number selected in the blue slicer
- Loan 21 is new and has no price yet. So want to find yield where price is average of similar historical loan
Hi azale2407 ,
please send the excel table through a One Drive LInk or copy-paste the table in text format