cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jt4 Frequent Visitor
Frequent Visitor

Days since last incident

Hi,

 

I am very new to Power Bi and would like some help in creating what is a simple spreadsheet where I can track days since the last incident across all departments.

 

We use Microsoft Dynamics (CRM) to record such data and I have a live link to this through Power Bi, I would like to move away from spreadsheets and the need to refresh and then use the spreadsheet to create Dashboards and instead just refresh through Power Bi if possible?

 

A step by step answer would be really useful 🙂 

 

Thaks in advance,

 

John


Days since last incident spreadsheet.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
JosefPrakljacic Established Member
Established Member

Re: Days since last incident

Hey @jt4 ,

 

here you have an example file.

 

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

View solution in original post

3 REPLIES 3
JosefPrakljacic Established Member
Established Member

Re: Days since last incident

Hey @jt4 ,

 

would you please provide us some sample data so that why know by what dimensions you would like to slice the "LastIncidentDates".

Here are some measures how I would do it in the simplest case.

 

LastIncidentDate = MAXX(Incident,Incident[IncidentDate])
DaysSinceLastIncident = DATEDIFF(TODAY(),[LastIncidentDate],DAY)

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

jt4 Frequent Visitor
Frequent Visitor

Re: Days since last incident

Hi Josef,

 

The formulas are great and probably just what I needed but I need to know how to get to the point where I can use these?

 

Can you advise what sort of sample data you are asking for over and above what was pasted in the last message?

 

Cheers,

 

John

JosefPrakljacic Established Member
Established Member

Re: Days since last incident

Hey @jt4 ,

 

here you have an example file.

 

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 398 members 3,302 guests
Please welcome our newest community members: