Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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.
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.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Thank you so much sir for show me right track of filter.
I have done another way to find solution exactly what I want.
Please help me how will do.
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.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
111 | |
59 | |
57 |