Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I need a measure to calculate the workingsdays dynamic based on a condition.
This condition is based on a slicer.
Please take a look @ the test file with the expected results.
Greets,
https://1drv.ms/u/s!An5X7wdH9O9ejkV1DFpGsk1xfF2e
Ronald
Solved! Go to Solution.
Hi @Ronald123 ,
There is a detailed blog on this on how you can calculate working days using start date and end date:
https://blog.enterprisedna.co/calculate-workdays-between-two-dates-in-power-bi/
Thanks,
Pragati
Hi @Ronald123 ,
There is a detailed blog on this on how you can calculate working days using start date and end date:
https://blog.enterprisedna.co/calculate-workdays-between-two-dates-in-power-bi/
Thanks,
Pragati
Helle @Pragati11 ,
I got stuck on the dynamic END DATE based on the slicer [disconnected table].
Could you take a look @ the Test file?
Greets,
Ronald
Hi @Ronald123 ,
I don't understand what you want me to look at. I see the following in your testfile:
The blog I shared doesn't talk about any disconnected table.
Please be detailed on what issue you are facing.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks,
Pragati
@Pragati11
My bad, i don't know how to implement below condition in the code from the blog.
Could you help me to make the measure in the test file?
Greets,
Ronald
Variable condition
END DATE IF ( Date Slicer < END DATE then SLICER else END DATE
Hi @Ronald123 ,
Apologies for not responding earlier as somehow I didn't get a notification for your above response.
Were you able to resolve the issue?
Thanks,
Pragati
Hi @Pragati11 ,
My way of thinking was wrong, thanks for put me on the right track.
Greets,
Ronald
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |