Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
85 | |
76 | |
73 | |
70 | |
57 |
User | Count |
---|---|
104 | |
99 | |
93 | |
78 | |
69 |