Forum Discussion

processman's avatar
processman
New Member
8 years ago
Solved

Time Intelligence doubt

I have a project where instead of dividing the year into 12 months I divide it into 18 periods. Then I have a column that joins the year and the period for example 201701 (year 2017, period 01), 2018...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi processman,

     

    Instead of measure, you could create calculated columns in this scenario.

     

    Year = LEFT(Query[Period],4)

Sales previous year Column =
CALCULATE (
    SUM ( Query[Sales] ),
    FILTER ( Query, Query[Period] = EARLIER ( Query[Period] ) - 100 )
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi processman,

 

Instead of measure, you could create calculated columns in this scenario.

 

Year = LEFT(Query[Period],4)

Sales previous year Column =
CALCULATE (
    SUM ( Query[Sales] ),
    FILTER ( Query, Query[Period] = EARLIER ( Query[Period] ) - 100 )
)

 

Best regards,

Yuliana Gu