Relative Change

[Anonymous]

I'm trying to create a table which shows the top N entities that experienced the largest amount of change relative to the previous month (actual quantities or percentage change, doesnt matter). I have tried the following DAX query but it doesnt work because one of the columns carries string types.

Measure = sum('CLIENT DATASET'[Model Breach])-CALCULATE(SUM('CLIENT DATASET'[Model Breach]),PARALLELPERIOD('CLIENT DATASET'[Time of Breach].[Date],-1,MONTH))

Any other way I can create something like this?

[wdx223_Daniel]

maybe you need convert the data type of [model breach] from text to number

[Anonymous]

but the data in that column are all strings, is there another formula or solution to this type of problem?