Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
My data compries of fiscal year and month columns. Fiscal year in my case is from July to June.
Is there a way to convert these to calendar dates and year in PowerQuery?
Snapshot of the data is as follows:
Thanks,
Danish
use cloumns from example
Tried doing it. It is hard coding instead of understanding the logic
Plese show example of your expected output
Output should be as follows:
Thanks
Danish
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |