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

Table with incidents closed and opened by rows

Hi,

 

I have an incident table with all records opened and closed on last 6 months, but i need to build a table as i show below, i need to show a resume of Open and Closed record on a selected period(filter), It's important to show a column with a hard-coded text, is there a way to achive this:

Incidents-table

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Regards,

BrunoR

1 ACCEPTED SOLUTION

@brunoemr solution is attached you can tweak it as per your need.






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.





View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

@brunoemr how does your raw data looks like? What kind of relationship you have in your model? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






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.





brunoemr
Frequent Visitor

I have two tables.

A table of all incidents, each record have Opened and Closed period, number and other fields.
Date Dimension Table, related with Incidents by Open Period column.

I need to produce a table that show count of records open and closed( in different rows) based on a Period Slicer(From date Table). Besides that i need to have a column showing the the same count on last month.

 

Incidents Table:

NumberStatusOpenClosedOpen PeriodClosed Period
INC1234Open23/10/2019NULLOct 2019NULL
INC1235Wip05/11/2019NULLNov 2019NULL
INC1236Closed15/10/201918/10/2019Oct 2019Oct 2019
INC1237Closed25/11/201926/11/2019Nov 2019Nov 2019
INC1238Closed23/10/201929/10/2019Oct 2019Oct 2019

 

What I am expecting are results like:

PeriodStatistics ReferenceCountCount Last Month
Nov 2019Open Incidents23
Nov 2019Closed Incidents12

 

Regards,

BrunoR.

@brunoemr solution is attached you can tweak it as per your need.






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.





View solution in original post

brunoemr
Frequent Visitor

Thanks.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.