Year To Fiscal Month Start Date

Question

Why does this not worK? I am trying to get Year to Fiscal Month Start date -1&nbsp;UnitCountYTFMSD = CALCULATE(COUNTROWS(FactWholesale),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATESBETWEEN(FactWholesale[INV DATE (I10)],MIN(DimDate[FiscalYearStartDate]),min(DimDate[FMSD])),filter(DimDate,DimDate[IsCurrentFiscalYear]=1))&nbsp;FMSD&nbsp; =&nbsp; DATEADD(DimDate[FiscalMonthStartDate].[Date],-1,DAY) which appears to be working fine.&nbsp;Maybe there is a better way to get YTFMSD, if there is please let me know.

vazmor · Answer

What I understand is that you are trying to get for example if your fiscal year starts in July that the calculation takes you June or want it to be 07/01/2017 -1?

iamcare · Answer

Our fiscal year started 8/27/2017 and the current fiscal month started 7/1/2018.&nbsp; I need to get a count from 8/27/2017 thru 6/30/2018.

v-yulgu-msft · Answer

Hi&nbsp;IAmCare,
&nbsp;
Would you please provide some dummy data to make the formula more readable? Also, please illustrate the desired result with examples, show us how to calculate it correctly.
&nbsp;
Regards,
Yuliana Gu

iamcare · Answer

Yes thank YouINV DATE (I10)UNIT KEY8/28/201710X512928/29/201770X446448/31/201770X447059/1/201710W9623612/19/201770X4481512/19/201770X448772/6/201810X537992/6/201810X541544/12/201810Y571026/14/201815Y164996/29/201810W506137/2/201810Y548697/23/201870Y45809I am also using a DimDate dimension.&nbsp; For my YearToFiscalMonthStartDate I should get a count of 11 because the last 2 are in July which is the current fiscal month

iamcare · Answer

Actually what I would like to see is Accumulating4 for september6 for sept thru dec8 thru Feb9 Thru April11 Thru June

Forum Discussion

Year To Fiscal Month Start Date

5 Replies

Related content

Start table with first month of fiscal year

Fiscal year and month

Fiscal Month Name

User Group Leader Get Started Guide

Calculate Fiscal Year starting in July

INV DATE (I10)	UNIT KEY
8/28/2017	10X51292
8/29/2017	70X44644
8/31/2017	70X44705
9/1/2017	10W96236
12/19/2017	70X44815
12/19/2017	70X44877
2/6/2018	10X53799
2/6/2018	10X54154
4/12/2018	10Y57102
6/14/2018	15Y16499
6/29/2018	10W50613
7/2/2018	10Y54869
7/23/2018	70Y45809