Need help on Dax for KQL query

[rajutechstar]

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

[rajutechstar]

can anybody provide SQL query for above kql queries?

[ERD]

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.