Forum Discussion
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...
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
Hi processman
If you add the measure that i refer and added it to you rable.visual you.will get thst exactly same.look.
Regards,
MFelix
If you add the measure that i refer and added it to you rable.visual you.will get thst exactly same.look.
Regards,
MFelix
You were right, it looks excellent. Now the problem I have is that by using a year filter, the "sameperiodlastyear" is no longer displayed, since the filter shows information about the chosen year but not the previous one. Is there a way to filter the current year, see the associated data of the previous year?
- Change the formula.to
Sales previous year =
VAR CurrentPeriod =
MAX ( Table[Period] )
RETURN
CALCULATE ( SUM ( Table[Sales] ); Table[Period] = ( CurrentPeriod - 100 ) ; ALL(Table[Period]))Great, now I have a new problem. When I work with years the attribute "max" in the formula is not useful. It would be ideal to return the sum of each of the periods involved (either 1 or 18). Can you help me?
- Hi processman,
Make a measure like this
Sales totals = IF(HASONEFILTER(Table[Year]) ; [Sales previous period] ; SUMX(ALL(Table[Year]); [Sales previous year]))
Regards
MFelix