Forum Discussion

Cyrilbrd's avatar
Cyrilbrd
Helper IV
3 years ago
Solved

Aging performance issues

Hi, I am getting poor performance form PBI Desktop with the following measure: Aging = DATEDIFF(AVERAGE(TDate_creation[date creation]),today(),year) I tried at first to create a custom column bu...
Need Help
  • Cyrilbrd's avatar
    Cyrilbrd
    3 years ago

    I created a new column direclty in PBI Desktop using:

    aging = DATEDIFF(TDate_creation[date creation],today(),YEAR)

    The performance is now back to normal. 

amitchandak's avatar
amitchandak
Super User
3 years ago

Cyrilbrd , You should be able to create a new column like , in the table TDate_creation

Aging = DATEDIFF(TDate_creation[date creation],today(),year)

 

 

or a measure =

Aging = AverageX( TDate_creation ,DATEDIFF(TDate_creation[date creation],today(),year) )

 

 

 

  • Cyrilbrd's avatar
    Cyrilbrd
    Helper IV
    3 years ago

    amitchandak 

    Thanks, I was able to figure it out.
    All works fine now.
    It is often confusing however to figure out if the editor, or the desktop or a measure works best... imo