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
parry2k's avatar
parry2k
Super User
8 years ago

basically you need to unpivot your date range and then join with calendar (date dimension) to get the count by month, quarter or year.

 

Let me know if you need help on how to do this

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?