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
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.