Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is the generated code
GP MoM% = VAR __PREV_MONTH = CALCULATE([GP], DATEADD('Calendar'[Date], -1, MONTH)) RETURN DIVIDE([GP] - __PREV_MONTH, __PREV_MONTH)
However if I look at the end of a month at a daily granularity, say for ex 30 & 31st May its calculating a percentage for both using the Value of April 30th as there is no April 31st. Should it not be blank instead?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.