Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |