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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
manubk
Frequent Visitor

Card Visual with Text and Time since last Incident timings

Hi All,

 

I want to create a card where If there is a New Major Incident date in the Actual Start column it should reflect in card as (Currently Major Incident Running ) else it should show the Timings in Card as Time since last incident (Duration) Below is the example of same 

 

manubk_0-1712925447953.png

For Example - Under Actual start if the date is added new (New Incident created) then in the Time Since last major incident card it should reflect (Currently Major Incident Running) else it should consider the latest End Time minus Today(Duartion)

 

@PBCommunity @community 

 

Regards,

Manu B K

2 REPLIES 2
3CloudThomas
Super User
Super User

Create a measure using TOPN (where N is 1)
TOPN function (DAX) - DAX | Microsoft Learn

The other option is to use a Filter pane and select Top 1

Hi @3CloudThomas Thanks for your reply . My qustion is If there is a New incident and End CST is blank in Card visual it should show (Currently MI Running) Else it should subtract the latest End Time CST to today.

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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