Some DAX functions will return a single date. Let’s go through some of these with our dataset.
STARTOFMONTH
If we apply this to our data without a filter, it will find the start of the first month:
LASTDATE
ENDOFQUARTER
Applying this to 2016, it uses the first 2016 record (09/02/2016) and gets the end of that quarter:
THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.
I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.
IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.
THANK YOU, AND LET'S KEEP LEARNING TOGETHER.
CARL
