Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |