Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Creating a splicer with title "Has Due Date?" with True or False checkboxes. Coded an if statement that recognizes if field was left bank then it is false and if the field has a date it is true.
hasDue = if(ISBLANK(MX_TICKET[TARGETFINISH]),FALSE(),TRUE())
Would like to add an overdue option. How do I add this to my statement and link current date to due date then identify if it overdue?
Hey @klb0066
I'm guessing [hasDue] is a column, so, you could either a) create a new column and refresh the model every day or b) have a measure and have a table visual with what you need.
a)
isDue = IF ( [hasDue] && [TARGETFINISH] <= TODAY() , TRUE(), FALSE() )
Which checks if your [hasDue] is true and the finish target was before or today. One thing you may want to check with your data is whether you have items which are already finished in your table. If so you'll need another clause like NOT([Completed]) or [CompletedDate]=BLANK()
b)
isDue = VAR d = SELECTEDVALUE ( MX_TICKET[hasDue] ) VAR tf = SELECTEDVALUE ( MX_TICKET[TARGETFINISH] ) RETURN IF ( d && tf <= TODAY (), TRUE (), FALSE () )
Which does the same as previous, but the table visual should contain a table key (meaning no row is aggregated)
Hi @klb0066
Create a calculated column
overdue = IF(ISBLANK([target]),BLANK(),IF([date]>[target],1,0) )
Best Regards
Maggie
Created this statement for a splicer
hasDue = if(ISBLANK(MX_TICKET[TARGETFINISH]),FALSE(),TRUE())
Identifies blank entries as false and entries that have a date as true. I want to add and overdue checkbox. How do I relate current date to due dates then pull out over due pieces?
what is the logic to create overdue option?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
It is for work and you are allowed to enter the due date or enter no due date (we are changing this procedure as entering in no due date is pointless now). I want to be able to see what work is overdue that has a due date.
Hi @klb0066
What do you mean by "you are allowed to enter the due date or enter no due date"?
If your current date is a column which exsits in the table, you can use the following formula
create calculated column, then add this column to a slicer
hasDue = if(ISBLANK(MX_TICKET[TARGETFINISH]),FALSE(),TRUE())
cretae a measure, then add this measure to the Visual Filter
if over due = IF(MAX([TARGETFINISH])>MAX([current date]),1,0)
If the current date refer to today, you can use TODAY( ) to replace [current date].
Best Regards
Maggie
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |