Forum Discussion

JLaine's avatar
JLaine
Helper I
8 years ago

Help needed graphing a count between a date range

I am new to using Power BI, and am looking for some guidance with the following:   I have a large SQL data set (larger than I can work with in Excel) contianing many data columns including the foll...
Need Help
JLaine's avatar
JLaine
Helper I
8 years ago

parry2k, The data is not currently 'pivoted' (as far as I know); it is just the source SQL query results at the moment.  As for the "join with calendar (date dimension)"; please tell me more about this, as this is something new to me.

parry2k's avatar
parry2k
Super User
8 years ago

i guess easier will be with sample pbix, let me see if i can put together something quickly for you. 

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    you can download the solution here 

     

    it uses your example serial number and showing by quarter.

    • JLaine's avatar
      JLaine
      Helper I
      8 years ago

      parry2k, thank you for that sample.  I notice there are two data tables, with one being a calendar; did you have to manually create this data table?

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        yes, there are many ways to create it, it is best practice to have continuous date (calendar) table in your model for time intelligence related analysis.

         

        there is dax function called calendar which populate the table with provided date range, link for reference and rest of the columns are just simple formulas, it can also achieved by power query and there are several way to do this, here is link for you to test that. There are many topics and you can search on it.