电源BI |过滤并选择高于参考值、给定附加条件的值 [英] Power BI | Filter and select values higher than a reference, GIVEN ADDITIONAL conditions

问题描述

我最近被聘为实习生，我所在领域遇到的一个挑战是如何突出最近的可用医疗预约.

I've been recently hired as an intern, and a challenge my area has come accross is how to highlight the closest available medical appointment.

当然，我知道在 excel 中这样的事情会非常简单，使用像 {=MIN(IF( range > current_date_and_time ; range ))} 这样的矩阵公式，因此，在 PowerBi 中，它应该同样简单.

Of course, I know that in excel such a thing would be pretty simple, with a matrixial formula like {=MIN(IF( range > current_date_and_time ; range ))} and as such, in PowerBi it should be just as simple.

但是，该区域正在处理的 PowerBi 表显示了整个议程，另一列指示它是否已被保留(带有 1 和 0).所以，我想知道如何结合这个条件 toe excel 公式，最后，如何在议程中获得最近的可用约会.

However, the PowerBi table the area is dealing with shows the entire agenda and another column indicates if it has been reserved or not (with a 1 and 0). So, I'm wondering how to incorporate this condition toe excel formula, and in the end, how to get the closest AVAILABLE appointment in the agenda.

最终的想法是应用这个过滤器"对于每个医生，然后按区域聚合.

Eventually, the idea is to apply this "filter" for each doctor, and then aggregate by area.

我也知道礼貌要求我向您展示数据，但这是工作相关的，所以我不能这样做.

I also know that good manners dictate I show you the data, but this is work related, so I can't do that.

先谢谢了，抱歉给您带来麻烦

Thanks beforehand, and sorry for the trouble

推荐答案

这个问题已经解决了，虽然是通过不同的答案.谢谢

the problem has been solved, though by means of a different answer. THANKS

这篇关于电源BI |过滤并选择高于参考值、给定附加条件的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！