Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hey,
I imagine that it would work with the CrossJoin function. I crossjoin your table with the refresh intervals and a date table.
This Date Table also has the frequency info maintained somewhere.
Then I apply the Filter Function to get the relevant data.
It could be that I need more than one Date Table.
BR,
Josef
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!