Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |