Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Mous007
Helper IV
Helper IV

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 ?
 
Thank you in advance.
1 ACCEPTED SOLUTION
EricHulshof
Solution Sage
Solution Sage

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


Did I answer your question? Mark my post as a solution!


View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

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.

 

sreenathv
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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


Did I answer your question? Mark my post as a solution!


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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.