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 ...
  • v-lili6-msft's avatar
    v-lili6-msft
    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

     

     

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

 

 

  • akariryusei's avatar
    akariryusei
    Regular Visitor
    7 years ago

    thank you v-lili6-msft for your help. I am able to generate the result now.

    :smileyvery-happy: