Count of days in financial year

[vincenttys]

Hi all,

I try to get the measure to calculate total days in a financial year.

I want the final output to show 365 days for 2021/2022. Even if i want to show my data by month, i also want it to show 365 days.

I have a date table and calculated financial year columns if that help.

Thank you

Regards,

Vince

[v-rzhou-msft · Accepted solution]

Hi  @vincenttys ,

Do you have a [financial year] column in your date table? If there is, you can try this measure.

Count of days =
CALCULATE (
    COUNT ( 'Date'[Date] ),
    ALLEXCEPT ( 'Date', 'Date'[financial year] )
)

If there isn't, you can add a [financial year] column in your date table then create the measure.

Financial Year =
IF (
    'Date'[Month] >= 7,
    'Date'[Year] & "/" & 'Date'[Year] + 1,
    'Date'[Year] - 1 & "/" & 'Date'[Year]
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MahyarTF]

Hi,

If you have Date, you could add the fiscal year to your Date Dim and then calculate the Count of the Days in each Financial year or put the slicer based on the particular field.

var _startOfFiscalYear=7 // set the month number that is start of the financial year. example; if fiscal year start is July, value is 7

"Fiscal Year",if(_startOfFiscalYear=1,YEAR([Date]),YEAR([Date])+ QUOTIENT(MONTH([Date])+ (13-_startOfFiscalYear),13))