Using Bex Query to import data into power bi

Anonymous, 

Have you tried playing with the code that I posted above. The code above will do what you need it do to, you simply need to exclude the day part and concatonate the year + month. Because your dealing with fiscaly period you'll have to append a 0 to the front of your month so you get 002 insetaed of 02 but other than that everything you need is posted in the code above. 

Give it a shot and if you have a specific issue post the code and we'll see what we can do.