whats the ideal way to join the calendar table and fact table when I want to calculate KPI based on dynamic date range for every month, like for ex: for monthly report of June : the start date and end date range is : 28/05/23 to 24/06/23 ( 28 days).
Hello @raniramachandra,
Thank you for contributing to the Forum by sharing your Post. To receive better assistance, please include a Power BI Desktop file that is still in progress, an Excel data file with tables, copies of referenced DAX measures, and images of your desired results. This is a standard requirement when submitting a Post to the Forum and allows other members to participate in the discussion.
–
If this post helps, then please consider Accepting it as the Solution to help the other members find it more quickly.
Did it contribute positively towards finding the final Solution? Please give it a like.