how to calculate ageing using DAX

[dsmitha]

Hi,

Request your guidance to solve this issue

I have a table which contains details of invoices,  my boss wants to calculate ageing of invoices, like if the invoice date is 7 days older then the colour of that row should change to amber, if invoice date is greater than 10 days then the colour of the row should change to red

kindly advice

regards,

dsmitha

[ronaldbalza2023 · Accepted solution]

Hi @dsmitha , hope you are having a great day. Sounds like a color formatting to me. Assuming that you already have dax for aging days. If wasn't, see here sample aging days measure Dynamic Grouping 

Aging Days Formatting =
SWITCH (
    TRUE (),
    [Aging Days] >= 7, "Amber", /*Check the hexcode for amber*/
    [Aging Days] >= 10, "Red", 
    BLANK ()
)

[dsmitha]

Hi ronaldbalza2023,

thank you for the quick and ultra simple solution,. it really helped me

thanks again

 

regards,

dsmitha

 

PREVIEW