Forum Discussion

gonrodrigues's avatar
gonrodrigues
Icon for Helper III rankHelper III
10 years ago
Solved

Variation Column

Hello!     I need to create a new column in "Variação" (variation in english) table, called "Var Headcount" in which the 1st row is:   [nr of rows with 'domingo, 1 de Maio de 2016' a...
  • sornavoor's avatar
    10 years ago

    Please see the below if it works for you.... 

     

    2 Steps:  

     

    Step 1 Count of related rows as a column in Date Table:

    QP Row Count = IF(COUNTROWS(RELATEDTABLE(QP))>0,COUNTROWS(RELATEDTABLE(QP)), 0)

     

    Step 2: Difference in Count from Prior Month:

     

    Difference From Prior Month = 'Date Table'[QP Row Count] - CALCULATE(SUM('Date Table'[QP Row Count]),DATEADD('Date Table'[Date],-1,MONTH))

     

     

     


    Data ModelQP Table

    Step 1 - Add a Related Row Count ColumnStep 2 - Add a Difference in Row Count from prior Month