Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm very new to Power BI and need a little help with Fiscal Year and Months. I took the DIAD class and am now trying to implement some stuff I learned into the class.
My table is set up like this:
I am trying to show revenue by fiscal year and month. I want the fiscal year format to show as YY/YY and our fiscal year starts on 7/1. Here is the weird part that makes things hard for me. The date column you see will not always coincide with the fiscal year and month. For example, a transaction on 7/3/2018 may have the fiscal year of 17/18 and fiscal month of June.
So how do I setup a column or table to recognize the fiscal year column and month column as the date with July being the first month?
@ThisIsHalloween hey, everything you need is in one of these 4 patterns, explained to details:
https://www.daxpatterns.com/time-patterns/
I didn't have much luck with that on how to connect how the data is setup back to dates.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |