difference between week values

Naveen_SV — Tue, 08 Dec 2020 09:34:55 GMT

Hello All,

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

Re: difference between week values

DataInsights — Sat, 26 Dec 2020 18:44:39 GMT

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

topic Re: difference between week values in DAX Commands and Tips

difference between week values

Re: difference between week values