<div>
Which specific SQL dbms are you using? &nbsp;SQL Server? Oracle? MySQL? &nbsp;The specifics will greatly affect the answer coding.
</div>


Which specific SQL dbms are you using?  SQL Server? Oracle? MySQL?  The specifics will greatly affect the answer coding.

<div>
My apologies. &nbsp;I'm using SQL Server and currently on 2017 version.
</div>


My apologies.  I'm using SQL Server and currently on 2017 version.

Information Technology

Daryl Chisholm

<div>
This was perfect, Scott!&nbsp; Exactly what I was trying to do!
</div>


This was perfect, Scott!  Exactly what I was trying to do!

<div>
<div class="content wysiwyg-content fr-view">
<p>I have a dataset that is projections for items with two categories. &nbsp;Each item has a projection for month periods through 2027. &nbsp;However I need to make them for everyday based on the projection divided by number of days in that month. &nbsp;I would do this manually but there are 18,000 records and I don't want to do it by hand. &nbsp;I would like to do this in a query or as much as possible and then export it out into power BI for a dashboard.</p>
</div>
</div>



I have a dataset that is projections for items with two categories.  Each item has a projection for month periods through 2027.  However I need to make them for everyday based on the projection divided by number of days in that month.  I would do this manually but there are 18,000 records and I don't want to do it by hand.  I would like to do this in a query or as much as possible and then export it out into power BI for a dashboard.

Creating dataset for everyday instead monthly with calculations.

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Power BI

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.