I am redoing the Power Bi file according to my needs.
I will not use different currencies.
I will not use Sector and Sensitivity.
I can not rewrite Dax Equity Value without taking currencies into account.
Equity Value = ROUND (SUM (VALUES (dbActive [ACTIVE])
; ROUND (
CALCULATE (SUM (fTrans [Qt-])
; DATESBETWEEN (Calendar [Date]; BLANK (); MAX (Calendar [Data])); All (Calendar)
; ALL (dbOper); DbOper [F IMPACT STOCK] <> 0;
* CALCULATE (Values (Quotation [Cot])
; LASTNONBLANK (
DATESBETWEEN (Calendar [Date], DateAdd (LastDate), -40; day), MAX (Calendar [Data])
; CALCULATE (COUNT [Quote])))
But it did not work.
Would you help me?