Lars Ole Sørensen
Member
Hi
I am trying to convert YTD data to MTD dato in a calculated column in Power Pivot. I get wrong number in the calculation for just one month, the calculation for period 31.07.2023 and cant find out why. Quantity YTD last month shows 42021 when it should be 1168.
I have attaced the workbook.

Thanks in advance for any help
I am trying to convert YTD data to MTD dato in a calculated column in Power Pivot. I get wrong number in the calculation for just one month, the calculation for period 31.07.2023 and cant find out why. Quantity YTD last month shows 42021 when it should be 1168.
I have attaced the workbook.

Thanks in advance for any help