Your step by step explanation are really powerful. Also like the emphasis on the context and need to use ALL()

Very useful, thank you. I made some adjustments and used it to calculate open invoices (entered, not paid) for any end of month in the data history.

Thank you very much, I was struggling for last two weeks to implement one scenario similar to this, and finally ALL() works like a magic. Your detailed explanation is much helpful. Although data are matching now but unfortunately facing poor performance. Note we have three dates in fact with which we need to apply filter conditions similar to what you explained and also we have direct query mode, not sure if the performance can be improved ☹️

Just what I was looking for, and using variables makes the code much cleaner. Thank you.

I was struggling with code to do this from another source and it kept screwing with my filters. Your solution solved my problem and is very clean. Thanks!

Great explanation again. I like the way you show the steps you take to come to the final solution. Especially for this for me hard to understand DAX-language: VARs which aren't vars, FILTER context, use of CALCULATE and not use FILTER within CALCULATE. Still have a lot of probs with DAX, so any concrete stepwise solution is helpful. Bedankt !!!!

I was trying various options, things like lastnonblank etc. another good video, i still have to check my results. mocked up small data set to practice on.

Love your explanation and pace. You got a new subscriber! Thank you.

That was awesome, just was I was looking for this week to find number of active student at a college month over month

Great explanation. I was able to modify for my needs. Thank you!. I am now trying to figure out a breakdown by an aging category. With this dataset I need to know for any given month, how many employees had less than 3 years of senority, how many 3-6, how many 6-10 and how many 10+. My dataset is open orders so I need to calculate for any given month how many open orders were less than 30 days old, how many 31-60, 61-180, 180+

You have just done 1/3 of my dashboard thank you!

Truly a life saver. Thank you!

Brilliant and clear, many thanks

Hello, thanks for your excellent work. I have one question, what we need to change in the measure if we want to get open case by department over time ? have you this type of video ?

Thx Bass Another problem solved with this tutorial

Really helpful, anyway you could show this for time of day, for example how many open between 6am and 3pm? Also for events open that's stay open passed midnight.

god bless you, you saved my life

Thank you so much! This video helped me a lot!

This is very useful. How might I be able to enter any date and show the figure at that date please?

This was very helpful. Can you please let to know how I can get to know the employee number that are cumulatively added

Very helpful. Already subscribed. Thanks again!!

Thank you for this. It works really well, but when I create a drill through from it, it doesn't return the correct records and returns records that have closed prior to the end date. Anyone know where I am going wrong? Thanks

Thank you so much, this really helped me with distinctcount active accounts and closed accounts with open contracts dates and closed contracts dates. I did some editing. However, when I use the totalytd, it is not working. I’m wondering why?

This is brilliant. What about materialization cost for large tables?

Thank you ! You saved me 😍

Very helpful video brother!!

Bro this is great, I have a problem I want to create a bar char including Orders Created, and Orders Closed per week. But, I want to still show Orders Closed even if Orders were not created on that week, Thoughts?

Hi, This measure was very helpful. Thanks for uploading this video. Is there any way we can increase the performance of this measure because it usually takes 5 10 min to load the data. If you can help me with that it would be really helpful for me. Also, am i the only one facing performance issue with this?

In my case, I need to see the number of Active employees at the start of the month instead of the end of the month? I change the Var CurrentDate to Min but I am not getting the result I am looking for.

Does this not work with fields that have a time stamp as well?

Great video

This calculation definitely comes back over and over again hahahaha Is it the same as the one called "events on progress" by the SQLBI guys?!

I found this very fhelpful but for some reason I didn't count the dates in the dimension table, rather the columns in my source table

Subscribed!!

Great video. I am using your method to show active subscriptions on some products. What if I want to view 1year, 2year, and 3 year active subscriptions? What kind of variable can I add for this?

Hi ! Thank you so much, very useful! But I encounter an issue. If I put a date filter in the page, because I want to focus only on active employee for 2020 for example, powerbi show me a wrong active number because it does not count hiring before 2020, because it is filtered, despite the usage of All(DimDate). Do you know why ?

kindly share .pbix file for practise ...it would be a great help for your active subscribers

Great video!, kindly share the file for practice.

what is dimDate? I did not understand.

Thanks again, your solutions are so smart. Sexy!