Forum Discussion
OFFSET Optimization for Large Dataset
I have a measure that is working as expected to determine the sum of the Total YTD Sales in the previous row in the Sales table when used on a partition (1 company key for 1 year('Product Sales'[Date...
PBIUser9090 , For YTD you can use window
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc