Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I have a column to calculate the overdue dates as follow:
Solved! Go to Solution.
Your current calculations are fine, and you can do the same for due soon items.
Also, you might consider making a top x of the negative values to show the next x amount of items going due the soonest.
This can just be done with the Top N in the filters pane 🙂
Quality over Quantity
Refer:
https://community.powerbi.com/t5/Desktop/Group-Measure-values-on-rows/td-p/514475
https://community.powerbi.com/t5/Desktop/Dax-query-using-calculated-buckets-as-filters/td-p/437466
You can create a color measure and use that in Advance condition or conditional formatting
Color Brand = if(FIRSTNONBLANK('Item'[Brand],BLANK())="Brand 11","red","green")
Color scatter = if(SUM(Sales[Net Sales])>2500 && SUM(Sales[Margin])>400,"green","red")You can combine the parameter and measure and create as per need.
For soon to be overdue items, you may use a calculated column with the following expression.
SoonToBeOverDue =
"OverDue within "
& FORMAT ( ROUNDUP ( DIVIDE ( Sheet3[OverDueDays], 30, 0 ), 0 ), "00" ) & " Months"
Your current calculations are fine, and you can do the same for due soon items.
Also, you might consider making a top x of the negative values to show the next x amount of items going due the soonest.
This can just be done with the Top N in the filters pane 🙂
Quality over Quantity
thank you all for your propositions.
I have used the Top N option as it was the easiest for me to implement.
Many thanks again
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |