First, this is how my DimensionsExchangeRate Table looks like.īasically, the Exchange Rate is to be used for Sales between Lower and Upper.ġ) Exchange Rate Measure:=AVERAGEx(FactsSalesTable, 1 * I will write below the formulas I've used, so you can understand better. If it is a measure, I can't manage to get it to work. However, what I'm having trouble with is creating the Running Total Product Sales GBP measure unless my Product Sales GBP is a Calculated Column. In fact, with some help from Marco Russo (God almighty), I have managed to write the Exchange Rate measure, and I have also managed to write the Product Sales GBP measure so basically you'd think that I don't need any of those columns.

I want to create Measures for everything, and not one single Calculated Column. Now you may be thinking 'Alright, good for you, now stop bragging and tell us what you want'. After this, I managed to create the Running Total Product Sales GBP column. I have managed to accomplish both things, and I did it by creating two Calculated Columns in the FactsSales table (Exchange Rate column and Product Sales GBP column). What I want is to convert all the sales in GBP and also to have Running Total Measure for Sales GBP. The FactsSales table contains sales from 2 countries, USA (in USD) and UK (in GBP), while the DimensionsExchangeRate table contains by-monthly Dates and Exchange Rates (USD to GBP). I have 2 different tables, one DimensionsExchangeRate table and one FactsSales table. I'll start with an explanation of what I'm trying to do. I consider myself fairly advanced in Excel, however I'm just starting to understand the capabilities of DAX and I'm here to learn. First of all, though it might be somehow irrelevant, this is my first post in the community, which is due to the fact that I've only started to learn DAX last week.

Another word for running tota