Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 ()
)
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 ()
)
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |