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:
Keep learning. Keep building.
Explore AI, agents & Microsoft technology.
I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.
Subscribe on YouTube →Carl de Souza Enterprise Architect at Microsoft · AI Technology Expert