Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I've been trying to figure out how to calculate the outstanding projects on power bi by using the dataset listed below. This dataset seen below is from excel with the calculation on how to get the outstanding projects. I want to try use a similiar formula to the one used in excel.
Please help ASAP.
@Anonymous , You have create an independent date table for slicer
then you can have measures like
Sumx(Table, Datediff([completion Date], selectedvalue([Date], today()) , day) +1)
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |