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 want to calculate current Fiscal Year End Date (April - March)
Solved! Go to Solution.
@Anonymous
Hi, try with this calculated column:
CurrentEndFiscalYear =
IF (
MONTH ( 'Table'[Date] ) <= 3;
DATE ( YEAR ( 'Table'[Date] ); 03; 31 );
DATE ( YEAR ( 'Table'[Date] ) + 1; 03; 31 )
)
Regards
Victor
That's really not a lot to go on. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Not a pro in dax. Can you please help on this. I tried formulas , but getting wrong data.
I am not clear on what you want. Are you saying that you want to have a "total ytd" measure that runs from April 1st, 2019 to March 31st, 2020 for example? If so, perhaps something like:
Measure =
VAR __Date = MAX([Date])
VAR __Year = YEAR(__Date)
VAR __FiscalEndMonth = 3
VAR __FiscalEndDay = 31
VAR __FiscalBeginMonth = 4
VAR __FiscalBeginDay = 1
VAR __FiscalBegin = DATE(__Year - 1,__FiscalBeginMonth,__FiscalBeginDay)
VAR __FiscalEnd = DATE(__Year, __FiscalEndMonth,__FiscalEndDay)
RETURN
SUMX(FILTER('Table',[Date] >= __FiscalBegin && [Date] <= __FiscalEnd),[Column])
No sir.
REPORTDATE | CURRFISCALYEAREND |
09-01-2015 | 31-03-2015 |
09-05-2015 | 31-03-2016 |
@Anonymous
Hi, try with this calculated column:
CurrentEndFiscalYear =
IF (
MONTH ( 'Table'[Date] ) <= 3;
DATE ( YEAR ( 'Table'[Date] ); 03; 31 );
DATE ( YEAR ( 'Table'[Date] ) + 1; 03; 31 )
)
Regards
Victor
Thanks bro, it worked.
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 |
---|---|
99 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |