Forum Discussion

alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
5 years ago
Solved

Poor Performance of Report

Hi All, I have a big sales tables which contains invoice date. I am calculating last_invoice as measure=   datediff(today(),max([Invoice Date]),DAY) When I am adding this to my table it takes ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    alexa_0028 

    Try one of the following:

    last_invoice  =   INT ( TODAY() -  SELECTEDVALUE ( TABLE[Invoice Date]) )
     

last_invoice  =   INT ( TODAY() - MAX ( TABLE[Invoice Date]) )
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

alexa_0028 

Try one of the following:

last_invoice  =   INT ( TODAY() -  SELECTEDVALUE ( TABLE[Invoice Date]) )
     

last_invoice  =   INT ( TODAY() - MAX ( TABLE[Invoice Date]) )
alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
5 years ago

This worked after creating it as calculated column instead of measure