Forum Discussion
Help pereparing my data for report
Thank you! I will follow your guidance and see if it will jave the desired output..I try to create like tracking report, to see how much is already spent each month... Its not a large dataset, i will start from the newest month (i have only two last months of data), It's only maybe 20 rows......I am trying to automate this.. so every time I will drop a new monthly file in the folder, I can only refresh the report and It should update the data. I saw tutorials about creating a data table but most of them shows the calendar for each day but I can create only monthly calendar, correct?
Hi, Just2431
First of all, appreciate your reply, and at the same time I am very sorry for my late reply. If your calculations require consecutive dates, then creating a calendar table would be a good decision. If you can complete the calculations in the original table, you don't need to create a calendar table. Under normal circumstances, creating a calendar will better help you practice based on the tutorials you browse.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.