How to have pivoted year and month in order

Power Query
1

Hi Team,

I tried to pivot in power query as per fiscal year and fiscal period.

I got the incorrect order for FY and FP as attached.

I also included expected result. I do not mind if the result heading are in month Year or FYFP as long as they are in order for 2 fiscal years.

Thank you.
QFYFPSorting.xlsx (31.6 KB)
Regards,

Aye

2

@ammu,

See if this works for you:

I created a concatenation of fiscal year and fiscal period, but padded the single date months with a zero so they would sort properly, then pivoted on that column using the Amount column as the values in the new created columns.

image
image1049Ă—407 10.1 KB

image
image1343Ă—358 28.2 KB

I hope this is helpful. Full solution file attached.

– Brian
eDNA Forum - Pivot Data Solution.pbix (28.3 KB)

1 Like
3

Hi @ammu, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!

4

Many thanks, Brian.
This is what I need, nice and sweet.
regards,
Aye