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
Hi, KarishmaDoshi
Typically, your data model will need a calendar table with continuous dates, which is important for time intelligence functions to work properly. I wonder if there is some error message. Please make sure the data type from two tables are all date when you connect them. If possible, please show us your sample data. Do mask sensitive data before uploading.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.