Help OR (Opening Receivable)

[SandeepKumar421]

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.

I have created hierarchy slicer "FY.EOM"

please help

[SandeepKumar421]

Sir, Can't do because I have multiple years 2021 to 2024. So As per indian FY. If I am selecting 31-08-2024 so opening year will 31-03-2024 . If I am selecting 31-08-2023 then opening year will 31-03-2023.

there is not fixed First Date

[SamWiseOwl]

Hi @SandeepKumar421 

You can still use FirstDate, it will return the "first" value in the current filter.

Sales for eom =

CALCULATE(

    [Sum of Qty]

    ,'calendar table'[eom] = Date(Year(FIRSTDATE('calendar table'[eom])),03,31)

)

So if you tick 31-08-2024, FirstDate will return 31-08-2024.

It will avoid the issue of SelectedValue returning a blank when there are multiple items in the column.

[SandeepKumar421 · Accepted solution]

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

[SandeepKumar421]

Please help me how will do.

[SamWiseOwl]

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.