Forum Discussion
Calculate not accumulated amounts from accumulated data structure
Sorry for being so verbous, it's my very first post on this community. I have source data structured as follows: Periods or Index Field Other Category Accumulated Amounts 1 A ...
AlexisOlson
Super User
Super UserKT_Bsmart2gethe This can work but is highly inefficient when the tables get very large.
marcofalzone01 I'd recommend checking out these prior similar posts:
https://community.powerbi.com/t5/Desktop/Calculating-Daily-values-from-Cumulative-Total/m-p/2198969
KT_Bsmart2gethe
Impactful Individual
Impactful IndividualAlexisOlson, I 100% agree with you.