Replace Table with your table name and then use the CALENDAR function to set the date range you want. You need to create the first column of the table which would be the date. In your report, in the Modeling tab at the top of the Power BI window, select New Table. In PowerBI we used the following formula: Using the New Table button on the modeling tab we were able to use a Dax expression that would create a date table that ranged from the earliest to the latest date in the activity table. One of the clients requirements was to track the employee hours to ensure they reached their goals, each had weekly targets but they also wanted to see the target percentage over a selected date range, so for example if the target was 32 per week for an employee and the dates analyzed was two weeks, the goal should be 64.įirstly, we needed a date table that included every day of the year based on the data received. In this case the client was using 32bit Access, so we installed the 32bit version of Power BI Desktop and installed Microsoft Access Database Engine 2010 Redistributable. Once the database was set up with the required data, we provided the user with the Power BI desktop application and created a dashboard with the required visuals and the data source coming from the Access tables. We added code to Access that would upload the data from the csv file and save to access tables which were connected to for reporting. The solution we provided was an Access database which allowed them to easily import their data from QuickBooks using QB reports exported to CSV, then having Access clean up the data and merge it with local tables to obtain the results needed. We recently had a client who wanted to view his QuickBooks data in Power BI, but the former could not connect with the latter to get the data, so we resorted to exporting the data from Quickbooks, using Access to clean it up and finally upload it to so that other employees can see the analysis.Īlthough can read QuickBooks data directly, (see ), our client needed reports that were not included.
0 kommentar(er)
