Next items to be overdue measure or column

[Mous007]

Hello everyone,

I have a column to calculate the overdue dates as follow:

overdue days = TODAY() - ' Report 01_2020'[ActionDueDate]

i the created another column for the overdue buckets;

Overdue Buckets =

SWITCH (

TRUE (),

' Report 01_2020'[overdue days] >= 0

&& ' Report 01_2020'[overdue days] <= 360, "0-12 Months",

'Report 01_2020'[overdue days] > 361

&& ' Report 01_2020'[overdue days] <= 720, "12-24 Months",

'Report 01_2020'[overdue days] > 721

&& 'Report 01_2020'[overdue days] <= 1080, "24-36 Months",

'Report 01_2020'[overdue days] > 1081

&& 'Report 01_2020'[overdue days] <= 1500, "36-48 Months",

"Not yet due" )

evertyhing is working fine for me although i know it can def be done in a better way ( i am new on power bi).

So my query is the following: i am trying to have a column or measure (whatever works better) to calculate and show the item to be DUE soon ( like in 1month, 2 months ... ). My not yet overdue items all have negative values and overdue items are all positive.

Any suggestions on how i can handle this with dax ?

Thank you in advance.

[amitchandak]

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.

[Anonymous]

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"

[EricHulshof · Accepted 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 🙂

[Mous007]

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