Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Incident Data

I have a spreadsheet with incident data (one incident per row). Information captured on each row includes the location of the incident and the type of incident.    At the moment, the PowerBI report...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous The best approach would be to have another table with location and the capacity and set relationship between your daily incident table wth this new table to calculate the %

     

     

Rujohn's avatar
Rujohn
Regular Visitor
5 years ago

Hi,

 

I am new here. I need help.

 

IF(Incident[Age of Incident]<7,COUNT(Incident[Incident Number]))
 
^^above is fine (no errors when I saved). this is to calculate the age LESSER THAN 7.
 
How do I write below?
 
Age is GREATER THAN 7 BUT IS LESSER THAN 14?
 
 
  • jthomson's avatar
    jthomson
    Solution Sage
    5 years ago

    Strange bump, but try this:

     

    IF(Incident[Age of Incident]<14&&Incident[Age of Incident]>7,COUNT(Incident[Incident Number]))

    • Rujohn's avatar
      Rujohn
      Regular Visitor
      5 years ago
      thank you sir. It worked! you're the best!