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.
Hi All,
I'm trying to calculate a number of days between two dates without weekends:
But I'm not getting any results back my new TAD column is blank =o?
Here is my dax formula i'm using:
I have created a new column in Dates table:
Then I'm creating a new TAD column to get number of days excluding weekends:
Am I doing something Wrong here???
Thank you.
Regards
Abduvali
Solved! Go to Solution.
Hi All,
It's actually was a bug after restarting Power BI its solved itself =oD
Regards
Abduvali
Hi @Abduvali,
Glad to hear that you have solved this problem. Would you please mark your sharing resolution as an answer so that it might help more users?
Regards,
Yuliana Gu
Hey Abdulvali,
When I used your TAD formula, it returns me with an error saying that a single value for column Due Date cannot be determined
This is my data structure
Do you know what I did wrong here?
Cheers,
Kev
Cheers,
Kev
after applying your steps i got wrong output
Please help me out
Hi @Abduvali,
Glad to hear that you have solved this problem. Would you please mark your sharing resolution as an answer so that it might help more users?
Regards,
Yuliana Gu
Hi All,
It's actually was a bug after restarting Power BI its solved itself =oD
Regards
Abduvali
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |