Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 end date in my original table.
The measures are
But my issue is I used the slicer of fiscal column it shows the FMinimum date and FMaximum date for all the year. I want to show filtered FMinimum date and FMaximum date belong to filtered fiscal years only. I created financial year column for 1 april to 31 march . I used this filter to show the maximum and minimum dates of records It shows the all the records with null values. I attach my screenshot and pbix for your reference.
Kindly check this pbix file for your reference. Help me as soon as possible..
https://1drv.ms/u/s!Aoy7ZnpipsSQa_GXKAEM3xBCBRo?e=cQ518k
Thank you
@Anonymous , if the tables are connected then use on min max for such cases
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.
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)
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.
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,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |