Displaying multiple values
Hi, Query fetching data from 2 tables which has 1-Many relationship and displaying on Matrix Visual. TicketNumber is commom fields between the two tables(1-Many relationship). DAX function : M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[SEVERITYDECODE]) M005-SLAStatus = VAR Restoration=[M001-HubTimeGroupInSeconds]/60 VAR Critical=180 VAR High=300 VAR Medium=10080 return if(HASONEVALUE(PRDetailHistory[SEVERITYDECODE]), SWITCH(TRUE(), AND(VALUES(PRDetailHistory[SEVERITYDECODE])="Critical",Restoration<=Critical),"IN", AND(VALUES(PRDetailHistory[SEVERITYDECODE])="Critical",Restoration>Critical),"OUT", AND(VALUES(PRDetailHistory[SEVERITYDECODE])="High",Restoration<=High),"IN", AND(VALUES(PRDetailHistory[SEVERITYDECODE])="High",Restoration>High),"OUT" ) ) Thanks. Best RegardsValues form multiple rows to one row
Hello, I would like to have values from multiple rows into one row. For this ID i have multiple dates in multiple rows which i would like to have in one row. I would like to do this in dax, because i filter these dates in multiple columns after i imported the data. Anyone an idea of how to do this?
Categorising Variances
Hello everyone - I'm looking for some support with a DAX problem. I have a table of results showing project details taken at various points in time (e.g. Project ID, Site Code, Start Date, Value), and the intention of the report I'm building is to measure any changes which have occurred between two points in time. My data has an 'export date' field of when the data was taken, and so far I've successfully create a report which allows two dates to be selected using slicers then produces a table of results showing the changes which have occurred along with a descriptive categorisation (i.e. New Project Created, Project Removed, Start Date Change, Value Change). Although this achieves my initial goal of measuring the changes, all the results are shown individually in a table view and what I also need to be able to do is present a dashboard view that answers more high level questions such as 'How many projects were delayed?' and 'How many projects have been added?'. So far the only way I've found of achieving this is to create a summarized table and then recreate the categorisation measure as a calculated column, however the main limitation of this appears to be that I can only use static dates, and not the slicer selections. The below link includes a crude mockup of the PBIX that I'm working on. Link: Categorising Variances PBIX Any support that anyone can offer would be warmly welcomed 😊
