Forum Discussion
[Help] Creating Monthly Test frequency visualization (Year-Independent)
Lycian Hi! Attack you can find the pbix with the solution. The output:
Hope it works! if you need to fix something, please send me details!
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
Hi Lycian
Just checking in on your query regarding the monthly test count based on test frequency and last test date, independent of the year.
As mentioned earlier, BeaBF has shared a detailed response along with a sample Power BI file demonstrating how to dynamically generate the expected monthly distribution based on the frequency type (Quarterly, Bi-Annually, etc.) and most recent test date.
Whenever you get a chance, please take a look at the provided solution and let us know if it meets your expectations or if any part needs further clarification.
Thanks again for reaching out!
Hi Lycian
Just following up on your question about calculating the monthly test count based on test frequency and the last test date, regardless of the year.
As previously mentioned, BeaBF provided a detailed explanation along with a sample Power BI file that demonstrates how to dynamically generate the expected monthly breakdown based on the frequency type (e.g., Quarterly, Bi-Annually) and latest test date.
When you have a moment, please review the shared solution and let us know if it aligns with your expectations or if you need any further clarification.
Appreciate your engagement!
Hi Lycian
Just following up regarding your query on calculating Monthly Test Counts (year-independent) for your test items dataset, where each item includes:
-
Coverage types (Front / Back),
-
Test frequencies (Quarterly, Bi-Annually, Annually, etc.),
-
And Test Dates with expected repeating patterns across the calendar year.
As per your requirement identifying the recurring test months based on the most recent test date and frequency, BeaBF has already reviewed the sample data you shared and provided:
- A customized solution
- A sample PBIX file with your logic implemented
- Output aligned with your expectations (e.g., Quarterly & Feb, May, Aug, Nov)
If we don’t hear back, we may close this thread in line with our community guidelines, but you’re always welcome to post a new query anytime.
Thank you for being part of the Microsoft Fabric Community!Thanks for your attention, and looking forward to hearing from you!
-