Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I am working on preparing consolidated financials statements for a company that has three entities. This involves converting the reporting currency of two of the entities to the third entities reporting currency.
The dataset has transaction level information. This means that to arrive at the balance sheet numbers, I will have to add transactions from inception to date. To achive this I have used a running total.
I have the exchange rates table from which I have looked up the latest exchange rate applicable to the cumulative total.
Hi, @Bopana
Simply share the code you write doesn't work and the screenshoots are vague. Can you share some sample fake data? So we can help you soon.
You can reference:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards
Janey Guo
@Bopana , Try this var like this and try
VAR Result =
CALCULATE (sum('Trial balance'[Transaction Amount]),
'Dates Table'[Date] <= LastVisibleDate,'Trial balance'[Country]="USA" && FirstVisibleDate <= LastDateWithSales )
Sorry this does not seem to work. Marked it as solved incorrectly.
User | Count |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |