Forum Discussion
DAX Calendar - Single script for MAT/QTR/4WKS/Week
Hi there, I have a need to be able to quickly create a calendar table that has non typical dates. All of my data is weekly data so we typically view MAT (52 Weeks), QTR (13 Weeks), 4Wks (4 We...
v-lionel-msft
Community Support
Community SupportHi RobbieRalph ,
Do you want to merge the three formulas "MAT", "QTR" and "4WKS" together? In other words, you want to return only one calculated column?
This is impossible. "MAT", "QTR" and "4WKS" are groupings of date columns. It is impossible for one column to return three different grouping results.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.