Forum Discussion
Fiscal Year Data - Month wise data
- 6 years ago
If you would like to time intelligence, Then you need continuous dates. So try to have a date in your tables.
Still, You can get the month table from the date table
month Date = SUMMARIZE('Date Table', 'Date Table'[Month Name], 'Date Table'[Year], 'Date Table'[Month No], 'Date Table'[Qtr No], 'Date Table'[Qtr], 'Date Table'[FY Qtr], 'Date Table'[FY], 'Date',Min('Date Table'[Date])) - 6 years ago
Very difficult to quite grasp what you are going for without seeing some sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, I often create a column like the following in my date tables to allow other table to connect to it:
YearMonth = YEAR([Date]) & FORMAT(MONTH([Date]),"00")
Values are output as 202001 for example
Now, with all that being said, See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
If you would like to time intelligence, Then you need continuous dates. So try to have a date in your tables.
Still, You can get the month table from the date table
month Date = SUMMARIZE('Date Table',
'Date Table'[Month Name],
'Date Table'[Year],
'Date Table'[Month No],
'Date Table'[Qtr No],
'Date Table'[Qtr],
'Date Table'[FY Qtr],
'Date Table'[FY],
'Date',Min('Date Table'[Date]))