Forum Discussion

UK_User123456's avatar
UK_User123456
Icon for Resolver I rankResolver I
6 years ago
Solved

Ranking and calculating the difference

Hi All,   I am working with Ranking and currently using RankX. I have multiple gift dates that could have been given by the same person over a period of time. I have ranked each of the gifts by dat...
Need Help
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Hi UK_User123456 

     

    Have you tried using the VALUE function to covert the result into a number?

    For example:

     

    Date Diff = VALUE ( [Last gift] - [Gift prior to last] )

     

    Best regards,

    Martyn

  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Hi UK_User123456 

     

    How about this?

     

    Date Diff = 
IF ( 
    NOT ISBLANK ( [Gift date prior to last] ),
    VALUE ( [Last gift date] - [Gift date prior to last] ),
    BLANK()
)

     

    Best regards,

    Martyn

MartynRamsden's avatar
MartynRamsden
Icon for Solution Sage rankSolution Sage
6 years ago

Hi UK_User123456 

 

I'm sure that the solution here is a simple one but it's almost impossible to troubleshoot without seeing how everything fits together in your model.

I appreciate you can't share your pbix 'as is' due to to sensitive data but are you able to anonymise it or create an exact replica of your model (including all measure and calculated columns) with a small sample of dummy data?


Best regards,

Martyn

 

 

UK_User123456's avatar
UK_User123456
Icon for Resolver I rankResolver I
6 years ago

MartynRamsden I will try and get a file uploaded with dummy data.

 

Thanks for your help.