difference between week values

[Naveen_SV]

Hello All,

How to get the difference between two weeks, below is the example

[DataInsights]

@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]: