question

DanielSanchezCO-4209 avatar image
0 Votes"
DanielSanchezCO-4209 asked MattAllington-5456 answered

DIVIDE IF formula for returning variations between two periods

Hello!! Im tryning to find the percentage variaton between two periods. I have the following formula: ![82471-image.png][1] [1]: /answers/storage/attachments/82471-image.png

power-query-not-supported
image.png (19.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MattAllington-5456 avatar image
0 Votes"
MattAllington-5456 answered

This is a DAX question and you have posted in a power query forum. If you read the error message, it tells you that you are missing the optional third parameter. If you don’t want to use the third parameter then you need to remove the comma at the end of line 4

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.