Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Just adding another post to clarify what I need.
Basically, I want this sql query translated into DAX:
SELECT TOP 10 To_Person,
Max(Call_Duration) as longest_call_duration
FROM [table]
where [date]= '2020-05-30'
group by
To_Person, Call_Duration
I Calculated Max Duration in Power BI like:
Hi @acg
Can you share a sample of your data here? do you want to create a table with to_Number column and just max10 duration?
You can add a RANK to your duration then filter that to 10.
Appreciate your Kudos✌️!!