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

That is surely a concern, will slow down the solution, not ideal in that case. Interesting. let's c what else we can do here.

parry2k's avatar
parry2k
Super User
8 years ago

how granular you want to see this warranty? Month Level/Quarter level/Year level.

 

Current solution will get you to day level 

  • JLaine's avatar
    JLaine
    Helper I
    8 years ago

    parry2k, at this point in time, I'm thinking that monthly granularity will probably be sufficient.  But if you are thinking of a chard by month, with count, know that I also need to seperate by product, and there are several thousand different [products] in the data set, which adds another level of complicaiton I did not want to start this thread with  (I'll be grouping those into product families and sub-families, to reduce the number of unique items to filter and chart)

  • tohare85's avatar
    tohare85
    Frequent Visitor
    8 years ago

    parry2k How would you use this solution to change it to monthly?

     

    Thanks,

    Tim

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    tohare85if you download the pbix file which i share in this thread, you can drop month name from your calendar table and you will get data at month level.

     

     

  • tohare85's avatar
    tohare85
    Frequent Visitor
    8 years ago

    parry2k Sorry, I meant how can you make it to where the "each" keyword iterates across months and not a new record for each day? Daily will make the data set too large.