Forum Discussion

Helper I

5 months ago

Solved

Calculate Based on Filtered Segment

I am in need of assistance to write formulas to determine % of total customers that were repeat within same calendar year % of total customers that were repeat lifetime Needs to calcuate by res...

mizan2390
5 months ago
hi jmorela1
I am not really sure what you actually want to do with your data. The data you have provided have aggregated value of the years along with a column Alltime. However, as SS attached, I tried to calculte. See the file wheter this solves your problem.
Corrected file: Repeat.pbix

If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread

mizan2390

Super User

5 months ago

hi jmorela1
I am not really sure what you actually want to do with your data. The data you have provided have aggregated value of the years along with a column Alltime. However, as SS attached, I tried to calculte. See the file wheter this solves your problem.

Corrected file: Repeat.pbix

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread