Forum Discussion

djreyes's avatar
djreyes
Icon for Helper I rankHelper I
3 years ago
Solved

Fiscal year

Hello,  Fiscal year starts April, I tried the formula below but I am getting an error message:   Column 2 = if(QUARTER(PowerBi[Document Date].[Quarter])>=2,QUARTER(PowerBi[Document Date].[Quarter]...
  • johnt75's avatar
    johnt75
    3 years ago

    The QUARTER function expects a date, but you're passing in the quarter from the date hierarchy. Try

    Column 2 =
IF (
    QUARTER ( PowerBi[Document Date].[Date] ) >= 2,
    QUARTER ( PowerBi[Document Date].[Date] ) - 1,
    QUARTER ( PowerBi[Document Date].[Date] ) + 1
)
  • johnt75's avatar
    johnt75
    3 years ago

    Yep, that should give the right result I think

djreyes's avatar
djreyes
Icon for Helper I rankHelper I
3 years ago

Still 1, I changed the value to 3 and the result is 4, is that an option? 

Column 2 =
IF (
    QUARTER ( PowerBi[Document Date].[Date] ) >= 2,
    QUARTER ( PowerBi[Document Date].[Date] ) - 1,
    QUARTER ( PowerBi[Document Date].[Date] ) + 3
)

 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Yep, that should give the right result I think