Is there an Equivalent expression in DAX for YEAR(TODAY()) for QUARTER?
Go to Solution.
I don't think there's an equivalent, but you can create your own.
Try using this:
=ROUNDUP('Date'[Month] / 3,0)
Or in your case
=ROUNDUP(MONTH(TODAY()) / 3, 0)
Hope that helps!
I'll give them a try, though I was hoping something like this would be integrated into DAX. Seems strange it isn't.
Hi @PaulDBrown,Please follow the solution @JoHo_BI posted, and give us response if you have any other issue.Best Regards,Angelia
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!