% of users : today vs yesterday

[neetu14]

I am trying to calculate the percentage change in the number of users today compared to yesterday for the number of users column to see the growth.

can someone help with the Dax measure for calculating the percentage?

[az38]

@neetu14 

it depends on your data model

in the most common case it will look like

Measure = 
DIVIDE(
CALCULATE(DISTINCTCOUNT(Table[UserID]), Table[Date] = TODAY()),
CALCULATE(DISTINCTCOUNT(Table[UserID]), Table[Date] = TODAY()-1)
)

[Syndicate_Admin]

I tried to use your formula

Percentage_Usage - DIVIDE(

CALCULATE(COUNT(Table[NumberOfUsers]), Table[SnapshotDate] - TODAY()),

CALCULATE(COUNT(Table[NumberOfUsers]), Table[SnapshotDate] ? TODAY()-1)

)

it is not giving any value 😞

[neetu14]

I tried using your formula

Percentage_Usage = DIVIDE(

CALCULATE(COUNT(Table[NumberOfUsers]), Table[SnapshotDate] = TODAY()),

CALCULATE(COUNT(Table[NumberOfUsers]), Table[SnapshotDate] = TODAY()-1)

)

it is not giving any values 😞

[v-jayw-msft · Accepted solution]

Hi @neetu14 ,

Check this measure

Measure = 
var today = CALCULATE(SUM('Table'[NumberOfUsers]),FILTER('Table','Table'[SnapshotDate]=TODAY()))
var yesterday = CALCULATE(SUM('Table'[NumberOfUsers]),FILTER('Table','Table'[SnapshotDate]=TODAY()-1))
return
(today-yesterday)/yesterday

Here's the result. Let me know if it works.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.