As a beginner to Power BI I probably have a relatively easy question :
I have a fact table that contains the price history of a certain asset (column named close):
Now I created a what if parameter in which the user can input the amount of stocks he owns. As a small detail I would like to create a card which shows the current total $ value of his holdings.
In other words: Todays value of the asset * the amount of stocks he owns.
I tried to create a formula with the LASTDATE function, but until now I haven’t succeeded.
It would be great if someone is willing to help me out.