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.
Hello,
How can I find the "Revenue in the first month" when using the Fiscal Year that starts on May 1st of every year?
I found a few answers in the Forum but they were all based on Calendar Year, not Fiscal.
this didn't work for me it shows all blank:
Hi @MuniqueCrespo,
I'd like to suggest you use the fiscal year tag field to find out correspond calendar date range of start/end date at first. Then you can use these date values as condition in the formula calculation to limit the calculation ranges.
formula =
VAR currFY =
MAX ( 'dCalendar'[Fiscal Year] )
VAR currDate =
MAX ( 'Table'[Date] )
VAR range =
CALCULATETABLE (
VALUES ( 'dCalendar'[Date] ),
FILTER ( ALLSELECTED ( 'dCalendar' ), [Fiscal Year] = currFY )
)
RETURN
CALCULATE (
[T. revenue],
FILTER (
ALLSELECTED ( 'Table' ),
[Date] >= MINX ( range, [Date] )
&& [Date] <= MAXX ( range, [Date] )
&& [Date] <= currDate
)
)
Regards,
Xiaoxin Sheng
Hello,
Thank you for your reply. To find the YTD values I have the Formula below which works fine for me. Your formula does the same as below. What I need help with is the find the YTD % Growth.
For example, if an investor’s portfolio was worth $200,000 at the beginning of the Fiscal Year and is currently worth $220,000 in the middle of the Fiscal Year, the year to date return is calculated as 10%.
HI @MuniqueCrespo,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |