Time Intelligence Calculations on Custom Date Groups

Copper Contributor

Hey everyone!

I have created a sales promo tracker for my team. As the team wanted to view their promo cycles, which have specific 3 week date periods, and vary per team member, I used the grouping function in Power BI to create custom date groups. I sorted these groups using a sort column.

I would now like to display time intelligence calculations to display a card with the growth for the current period vs. the previous period. I know time intelligence quick measures only work for standard Power BI Date Hierarchy, but I was wondering if I could adapt the quick measure DAX or I would have to write a measure from scratch?

I am not great with DAX as I only just started to use Power BI

1 Reply

@Lauren_Michelle 

That's better to ask on community.powerbi.com. Excel is similar but different story.