Mar 19 2023 03:58 AM
I'm working on currency exchange project for 6 months so far, when I made my first step I didn't had clue about the power of excel right now my eyes are wide open and enthusiasm to get my project to the next level, In simple terms I have a based currency Let's call it DL and every day I buy and sell DL/USD and DL/EUR based on the transaction type and region the cost will be added to the exchange rate.
I created a source sheet where I make my daily activities and with the use of power query
I transferred the the whole data to power query to represent it in the different view and accumulate each data type to analyze it separately, Now I need to get more specific to make an accurate solutions.
After 6 months of working and testing I faced some Issues like:
Hope I can get advanced help to keep my project running in professional way.
Down bellow I attached sample of my data.