cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Weatherreport
Frequent Visitor

DAX expression with 2 filters returning value

Hi All,

 

I would need a DAX expression that would return "Avg Time" based on 2 filters "KDS Date=yesterday" and "Queue=K1":

 

Weatherreport_0-1622689144996.png

In the sample above, the value to be returned should be "09:50".

 

Please note that "Avg Time" is a custom column and has been calculated as per below:

 

Weatherreport_1-1622689282408.png

 

Thanks you so much

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@Weatherreport , Create a measure like

calculate(sum(Table[Avergae Time]), filter(Table, [KDS Date]= today()-1 && [Queue]="K1"))

 

and convert to Min and second



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak 

Thanks for your answer.

Yes that definitely solves half of my issues. But how can I convert that measure into Min and Second?

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates