Forum Discussion
Calendar Table only in Months
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.
Super UserThanks amiitchandek, I had read through that and couldn't get that to make the difference to my coding. I'm not sure whether I'm not doing it right or whether three's a different solution but that didn't give me the required end result.
After some effort and thought. I can get the linked example to work, however as soon as I try to shift to meet a financial year it all goes somewhat wrong. The columns I need are:
Period - This is linked to our financial year and in the format 201901 (year month) I need this to be unique values
Financial Quarter - Year and Quarter (19Q1)
Month - Name
Accounting Year - split years 18/19
Month Year - month followed by the calendar year (Aug 19)
Our financial year is 1 August to 31 July and I have successfully built a table that built that but I can't link by the right factor. Unfortunately our Finance Department use Period to determine where costs are placed and the transaction dates can be misleading. I am never going to get that changing so much report differently.
v-juanli-msftCommunity Support
Hi Anonymous
The "Period", eg 201901, is it 2019/1 for the real date or for your financial year and month?
Best Regards
MaggieHi Maggie,
Financial Year and month, so 201901 would be August 2019.