Need help on Dax for KQL query

rajutechstar — Fri, 21 May 2021 02:59:40 GMT

Below is the KQL query, i need dax query in Power BI. Could you please provide me the DAX for below KQL queries

KQL1:

SecurityIncident
| where TimeGenerated > ago(100d)
| where FirstActivityTime <> ''
| where Status == 'New'
| summarize arg_min(TimeGenerated,*) by IncidentNumber
| extend TimeToTriage = (FirstModifiedTime - CreatedTime)/1s
| summarize min(TimeGenerated), FirstActivity=min(FirstActivityTime), Created=min(CreatedTime) by Title, ProviderIncidentId
| extend DetectTime = (Created - FirstActivity)/1m
| extend TileTitle = 'All'
| summarize MeanTime = percentile(DetectTime, 50) by TileTitle

KQL2:

UniqueIncidents

| where StatusList contains "Closed"

| summarize Total=count(),TruePositive=countif(Classification == 'TruePositive')

| extend Results = pack("Total",Total,"TruePositives",TruePositive)

| project Results

| mv-expand Results

| extend Title = iff(tostring(Results.Total)<>'','Total','TruePositive')

| extend Count = iff(tostring(Results.TruePositives)<>'',toint(Results.TruePositives),toint(Results.Total))

| project-away Results

Re: Need help on Dax for KQL query

rajutechstar — Fri, 21 May 2021 09:32:52 GMT

can anybody provide SQL query for above kql queries?

Re: Need help on Dax for KQL query

ERD — Sat, 22 May 2021 10:31:32 GMT

Hi rajutechstar ,

Try this article: https://docs.microsoft.com/bs-cyrl-ba/azure/data-explorer/kusto/query/sqlcheatsheet

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

topic Re: Need help on Dax for KQL query in DAX Commands and Tips

Need help on Dax for KQL query

Re: Need help on Dax for KQL query

Re: Need help on Dax for KQL query