Forum Discussion
Period Change Matrix
Hi, I am trying to do a matrix, screen shot below The period change is wrong as in 1H 2019 it should be 0%. Is there anyway to fix this? The total period change is correct but by indiviudal i...
Anonymous , You need to have a period table with Incremental period rank
a new column in the period table
Period Rank = RANKX(all(Period),Period[year period],,ASC,Dense) // or on period start date
then your measures can be
This Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])))
Last Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])-1))
diff = [This Period] -[Last Period]
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s