Forum Discussion

Vedantika_V's avatar
Vedantika_V
New Member
4 years ago

previous selected values and copare to current selected values less than RED

HI Expert, I have 5 filters  FilterName 1 Month 3 Month 6 Month 1 year   I have already Created DAX formula for Percentage   by default  I have selected 6 Month. if I have se...
Need Help
RafaelRSantos_'s avatar
RafaelRSantos_
Frequent Visitor
4 years ago

Hi, could you post your data frame to visualize?

I created a dax function once:

Previous Balance = 
VAR MinDate = CALCULATE( MIN('Public DimDate'[Date]), ALLSELECTED('Public DimDate'[Date]) )
RETURN
CALCULATE(
    SUMX('Account FactAccountMoviment',
    'Account FactAccountMoviment'[CreditValue] - 'Account FactAccountMoviment'[DebtValue])
    ,FILTER(ALL('Public DimDate'),'Public DimDate'[Date] < MinDate )
)

The var Mindate is possible to get the Min value from slicer, i think you have to get many dimension of date as you have in slicers to get each date.

 

Hope this help you