• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pass Date from Slicer to calculate retrospective Status count on the fly

D

dramnath5

New Member
I am trying to get a past date pending case count from a live database, based on the Date selected in the slicer. But what I have is not a daily snapshot to know what was the past status, but a live database. For example, a case might be closed yesterday which was created last month. Since that case was pending and not closed as of last month end, when I select a Date slicer as Last month, I want that case to be counted as Pending even when it got closed as of date. Similarly, as and when I chose the Date slicer, I would like to see the pendency status basis Date Slicer and not as of date.

Is this possible in Power BI? Any support to solve this issue will be of tremendous help.

Thanks a lot in advance.
 
You must log in or register to reply here.
Back
Top