The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
In addition to misuse all() function within datesbetween, I also swapped the position of start date and end date. Here is the correct measure to use:
Hi, @Anonymous
I am not sure how your whole data model looks like, but try to NOT USER ALL in datesbetween function.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
In addition to misuse all() function within datesbetween, I also swapped the position of start date and end date. Here is the correct measure to use:
Does that mean datebetween() doesn't allow another formula embedded? I want to calculate no. of leavers from current date back to 12 months ago. Maybe i should use filter() instead of datesbetween()