Forum Discussion

Naveen_SV's avatar
Naveen_SV
Icon for Helper IV rankHelper IV
5 years ago

difference between week values

Hello All,   How to get the difference between two weeks, below is the example  
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

Naveen_SV,

 

Try this solution. In this example, the data table is WeekDiff.

 

Create calculated table:

 

WeekDiffDates = VALUES ( WeekDiff[Date] )

 

Create a relationship between WeekDiffDates and WeekDiff.

 

Create measures:

 

Count of Country = COUNT ( WeekDiff[Country] )

Difference = 
VAR vDate =
    MAX ( WeekDiffDates[Date] )
VAR vCurrentCount = [Count of Country]
VAR vPrevDate =
    CALCULATE ( MAX ( WeekDiffDates[Date] ), WeekDiffDates[Date] < vDate )
VAR vPrevCount =
    CALCULATE ( [Count of Country], WeekDiffDates[Date] = vPrevDate )
VAR vResult = vPrevCount - vCurrentCount
RETURN
    vResult

 

In the matrix, columns should be WeekDiffDates[Date]: