I solved i!.: "Fill in missing exchange rate table between dates gaps"

[Anonymous]

I have solved it. The DAX exprssion is:

{

Exch_Rate_Complete =

VAR MissingDates = FILTER( ALL( DimDate[DateKey]);

DimDate[DateKey] > (MAX(DimDate[DateKey]) - 6) &&

DimDate[DateKey] <= MAX(DimDate[DateKey]) )

Return

CALCULATE([ExchRate]; LASTNONBLANK(MissingDates; [ExchRate] ) )

}

and the result table is:

However, I got problem to use it to calculate the total sales. I will create a new post to explain the next problem.

😉

/Dav

**********original problem*********

Hi,

Could someone help me with an example to fill up gaps of the missing exchange rate (both EUR & USD) between two dates?

 such as:

 

I need both the EUR & USD rates between 22 and 26 should be as it is on the 21 st, i.e. 10.2760 respective 8.9587.

All helps are appreciated and thanks in advance.

🙂

/Dav

[Greg_Deckler]

Sure, would be happy to try to assist but need more information. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous · Accepted solution]

Thanks Greg for tips. I will definately considerer your advices.

I am sure there are the anwers for my specific questions and if you know any good examples please let me know. All help is appreciated.Thanks again.

/Dav