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 selected 3 Month then we need compare 6Month vs 3 Month Percentage is greater values GREEN otherwise RED

same can selected filter one filter then should be compare previous Month selected.

I can selected any one then should be compare i am selected previous filter.

 

Please any own can help DAX formula.

 

I need creare Arrow Indicate

 

Thanks

Vedantika_S

Need Help

2 Replies

  • 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