Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relative Change

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?
 
 
change
DAX

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    5 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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