Forum Discussion
Calendar Table only in Months
Hi, I'm pretty new to building things using DAX, so am struggling with some programming syntax... I've built a table to recognise months, quarters and years for our financial year. It would...
Hi Anonymous
To get distinct Period, create a new table
Table 2 = SUMMARIZE('Table','Table'[Period],'Table'[Financial Year],'Table'[Financial quarter],'Table'[Financial month],'Table'[Month Year(Actual)])Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oh, I had a search and saw 2 posts that looked like they could have helped but didn't solve this one...