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.
This is the sample scenario and results
Hi @sph1nkz,
As per our understand you need to check if service type is MPLS, Radio, VSAT then Backup Status is equal to "Has Backup" And if service type is MPLS, but no Radio, VSAT then backup status is equal to "No Backup".
Create new Column with below DAX expression as shown in below,
Backup Status = IF('Table'[type]
IN {"MPLS","Radio","VSAT"} && 'Table'[Site Name]
in {"Site A Farm"},"has Backup","No Backup")
Below is the result :
If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.
Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
You need to group your row level (Site A/B) then return one value per row stating whether there is a backup or not. Your desired output table is inconsistent, as in that case MPL5 = both Backup and No Backup.
There are many ways to do it. You can group the Site Name column in query editor, choose SUM as the group function for your service type - it will return an error.
In the formula bar, change 'sum' to 'Text.Combine' and add the seperator
Add a custom column with the following:
if Text.Contains([Count], "Radio") or Text.Contains([Count],"VSAT") then "Has Backup" else "No Backup")
this is your result, you can join new the table on the Site Name if you want.
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 |
---|---|
112 | |
96 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |