Forum Discussion
Best Practice re Calendar table, Modeling, etc.
Hi Txtcher ,
To filter visuals for only FY2024-approved applications, follow these steps:
- Create a measure that checks if the application’s license issuance date falls between September 1, 2023, and August 31, 2024. If so, it returns 1 (approved for FY2024), otherwise 0.
- Add the Is FY2024 Approved measure to the visual-level filters of your matrix and set it to show only records where the value equals 1.
- To calculate the days between the "Submitted and Paid" and "Response Required" dates, ensure both dates are not blank and that the start date is less than or equal to the end date. If these conditions hold, use the DATEDIFF function to calculate the days.
- Use the CALCULATE function with the AVERAGE function to calculate the average of the "Days Submitted to Response" measure, but only for records where the application is approved for FY2024.
This ensures that your milestones and averages are correctly filtered for FY2024-approved applications.
Hope it helps!If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi Txtcher ,
To filter visuals for only FY2024-approved applications, follow these steps:
- Create a measure that checks if the application’s license issuance date falls between September 1, 2023, and August 31, 2024. If so, it returns 1 (approved for FY2024), otherwise 0.
- Add the Is FY2024 Approved measure to the visual-level filters of your matrix and set it to show only records where the value equals 1.
- To calculate the days between the "Submitted and Paid" and "Response Required" dates, ensure both dates are not blank and that the start date is less than or equal to the end date. If these conditions hold, use the DATEDIFF function to calculate the days.
- Use the CALCULATE function with the AVERAGE function to calculate the average of the "Days Submitted to Response" measure, but only for records where the application is approved for FY2024.
This ensures that your milestones and averages are correctly filtered for FY2024-approved applications.
Hope it helps!
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi Txtcher ,
Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!