Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
87 | |
78 | |
74 | |
70 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |