Hi! Thanks for the nice video. May I please ask a question: why we need bother using the filter from Calendar table? I guess we could directly filter by start_date or end_date? What do you think?
Downside of USERELATIONSHIP is that it doesn’t work with RLS (Row Level Security). I thought TREATAS would be a good workaround, but as you mentioned, having an active relationship causes problems. Any other alternatives besides duplicating tables?
Hi very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
You clearly expressed the diifference between the two DAX functions, TREATAS and USERELATIONSHIP.
This is exactly what I was looking for! Thank you so much 🙏🏻
You’re welcome!
Nice explanation. Thanks!
Thanks,its really useful for me
Glad to hear that
Very helpful, thanks!!
You're welcome, thanks for watching!
Hi! Thanks for the nice video. May I please ask a question: why we need bother using the filter from Calendar table? I guess we could directly filter by start_date or end_date? What do you think?
Downside of USERELATIONSHIP is that it doesn’t work with RLS (Row Level Security). I thought TREATAS would be a good workaround, but as you mentioned, having an active relationship causes problems. Any other alternatives besides duplicating tables?
Hi, i have tried it. But it seems that there has to be the same column in the other table too. with a one-to-many relationship. please guide
Hello, which better for performance?
Hi
very useful video and very practical need everyone for every project ......very big thanks to share with us.
If it can possible can you plzz provide us excel data file which you used.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Be very careful, sometimes it will give slightly different results
It almost seems like magic.