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.
Hi fairly new to BI and especially DAX.
I have a table that contains multiple alarms for multiple devices all with a unique alarm number. All have a time stamp received "Opened at". I want to compare month on month comparison of the amount of alarms received for each device.
I've tried a few different formulas and measures with no real success.
Basically need a count of alarms per device then a MoM comparison of how many alarms and display in a bar graph showing alarms received per month and drop of alarms in comparison to previous months, a positive/negative value bar chart.
Hope that makes sense.
I have used this formula in a measure which works on the count of device names but that's where I'm not sure of what is next.
Alarm Number Device Alarm Description Opened at
1 Dev1 Alarm dd/mm/yyyy hh:mm:ss am
2 Dev1 Alarm dd/mm/yyyy hh:mm:ss pm
3 Dev2 Alarm
4 Dev3 Alarm
5 Dev2 Alarm
6 Dev2 Alarm
TIA much appreciated.
Solved! Go to Solution.
Hi DAXterity,
You could referto my sample to see whether it work or not. you could use quick measure to achieve this goal
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Zoe,
I have updated the formula to match but all i get in the table is the device and the incident count. No data for the Year Month or MoM column.
I have the date table with link to opened at in the relationships.
The alarm number is actually alpha numeric would that cause any issues? INCxxxxxx
thanks
Thanks very much for that Zoe. This should work nicely.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |