Forum Discussion
How to link Custom Fiscal Calendar table with time attribute?
I'm not seeing a time component, so it doesn't look like you need time anywhere.
you should create a date table that has all of the attributes you need. The Date field must start at the beginning of your needs and go through the end, and there must be a record, and only one record, for each day. So Jan 1, 2019 through Dec 31, 2022 would be roughly 1,300 records.
You need to then add a lot of attributes. Month, Month Name, Year, Fiscal Year, Quarter number, quarter name, etc. You then filter by those attributes. The Date field is what should be connected to your Fact table.
Here is an example of a good date table you can expand on: Creating a Dynamic Date Table in Power Query
If you need more help, be clearer in the expectations of what you are trying to do. thanks!
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.