Forum Discussion
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. ...
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
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
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.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
