Forum Discussion

akariryusei's avatar
akariryusei
Regular Visitor
7 years ago
Solved

Alert Data

Dear Experts,

 

I am still new in power Bi and Dax . I have a question regarding my data. I have alert data set as below. I tried to create summarize column to generate the lists of DeviceID which generated the alerts since Jan 2018 - until Sept 2018 (not necessary everyday) for the same SituationMessage.

 

 

For example, DeviceID thnslsputil were generated alert since February 2018 until September 2018 due to device down.

 

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    HI, akariryusei

        After my test, you can do these as below:

    assume that this is basic data

    Step1:

    add two column

    Year = YEAR(Table1[LoggedTime])

Month = MONTH(Table1[LoggedTime])

    Step2:

    Create a calculate table

    alter table = SUMMARIZE(Table1,Table1[DeviceID],Table1[Year],Table1[Month],"countID",CALCULATE(COUNT(Table1[AlertID])))

    Result:

     

    here is pbix, please try it.

    https://www.dropbox.com/s/nct1bothjtptxv4/Alert%20Data.pbix?dl=0 

     

    Best Regards,

    Lin