Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Urgent Help---Filter issues

Hi Everyone,    I created one calender table by using start date and end date in that table I created columns for fiscal years.   Then  I created a two measures for  min of start date and max of en...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

    Thanks for your reply. I changed my measure based upon your suggestion but no changes appeared in that measure. The issue is also not solved. Kindly check my attached screenshot and help me on this issue.

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , Anonymous 

    Is this the expected result want?

     

    try measures as below:

    MaxDate of selectedFY = 
var selectedFY=SELECTEDVALUE('Calendar date'[Financial Year])
RETURN CALCULATE(MAX('Calendar date'[Date]),'Calendar date'[Financial Year]=selectedFY)
    MinDate of selectedFY = 
var selectedFY=SELECTEDVALUE('Calendar date'[Financial Year])
RETURN CALCULATE(MIN('Calendar date'[Date]),'Calendar date'[Financial Year]=selectedFY)

    pbix attached

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-easonf-msft ,

           Thanks for your reply. I saw your pbix file and screenshot you are showing the maximum and minumum dates by using calender date thats okey. But, my issue is not the min and max dates..

      I this screen shot If I click the fiscal years filter for 2022 to 2023 it shows the max and min date between the fiscal years only, the fiscal years starts in April 2022 to march 2023. But, books category min and max date is not the filtered fiscal years but it displays the date with empty datas also thats my issue I tried but not works for me... kindly help me on this issue..

      Advance thanks,