i have a question about Time-Intelligence functions.
I created a 544 fiscal calenar in powerQuery and now I am looking for a way to compare values on the last day of each month.
My fiscal calendar starts on sunday --> May is 06.05.2018 - 02.06.2018
Now I want to compare the values of 02.06.2018 and 05.04.2018.
Does anybody know, how to build that formula?
Go to Solution.
Do you have your Fiscal Month as column? I recommend to add FiscalMonthNumber as basis to calculate:
So you could
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!