cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Next items to be overdue measure or column

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution Supplier

## Re: Next items to be overdue measure or column

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 🙂

4 REPLIES 4
Solution Supplier

## Re: Next items to be overdue measure or column

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 🙂

Solution Specialist

## Re: Next items to be overdue measure or column

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"``````

Super User IV

## Re: Next items to be overdue measure or column

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.

In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin

Helper I

## Re: Next items to be overdue measure or column

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

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors