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
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
)
)
RETURN
Opening_Value