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 but the editor would not accept the syntax of DateDiff.
The table containing the date of creation contains rows that are NULL, could this be the reason?
Or is the issue with the measure? 

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. 

3 Replies

  • 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

  • Cyrilbrd's avatar
    Cyrilbrd
    Helper IV
    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.