Forum Discussion

KarishmaDoshi's avatar
KarishmaDoshi
Regular Visitor
6 years ago
Solved

Fiscal Year Data - Month wise data

I am new to Power Bi. I have data from April 2015 to January 2020. The fiscal year is April-March. The data is monthly and not daily eg. sales for April 2015, May 2015, June 2015 and not daily date b...
  • amitchandak's avatar
    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]))

     

     

  • Greg_Deckler's avatar
    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