Forum Discussion

SandeepKumar421's avatar
SandeepKumar421
Regular Visitor
1 year ago
Solved

Help OR (Opening Receivable)

Hello Friends, I need a help to get the opening receivable.   Like  I have selected 31-08-2024 in slicer but I need data of year(2024,3,31). Please not getting even I have created a measure. ...
Need Help
  • SandeepKumar421's avatar
    SandeepKumar421
    1 year ago

    Thank you so much sir for show me right track of filter.

    I have done another way to find solution exactly what I want.

    Ageing of OR New V1 =

    Var Opening_Date = DATE(YEAR(EOMONTH(EDATE(SELECTEDVALUE('Calender'[EOM]), -3),0)),03,31)

    Var Opening_Value =
    CALCULATE(
        SUM('Ageing'[Pending]),
        FILTER(
            ALL('Calender'),
            'Calender'[EOM] = Opening_Date
        )
    )

    RETURN

    Opening_Value
SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

Hi SandeepKumar421 

Could you hover over the funnel on the card, this will show any other filters.

When I tried it worked perfectly...

You could try using LastDate or FirstDate instead of SelectedValue.

SelectedValue will return a blank if multiple items are selected.