Forum Discussion
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.
I have created hierarchy slicer "FY.EOM"
please help
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))RETURNOpening_Value
5 Replies
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.
Please help me how will do.
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 DateYou 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.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))RETURNOpening_Value
