Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
1. Sorry for my English.
2. Here is the question.
I have gaps in dates, because rates set up not every day.
What i need is a measure that give me day to day values of rates.
for example:
Date-Rate
07/03/18 - 26.60
13/03/18 - 26.20
16/03/18 - 26.50
03/04/18 - 26.30
the goal is to have
07/03/18 - 26.60
08/03/18 - 26.60
09/03/18 - 26.60
10/03/18 - 26.60
11/03/18 - 26.60
12/03/18 - 26.60
13/03/18 - 26.20
14/03/18 - 26.20
etc.
I know that this is VERY easy task, but i cant handle it.
3 tables.
2 dimention tables: DimCurrency (PK Guid), Calendar (PK Date)
1 fact table: FactCurrenciesRates (FK DimCurrency.Guid, FK Calendar.Date)
Thank you all in advance.
Solved! Go to Solution.
@Anonymous,
Drag [Date] from Calendar table and add measure below.
Measure = VAR d = SELECTEDVALUE ( 'Calendar'[Date] ) RETURN CALCULATE ( LASTNONBLANK ( FactCurrenciesCourses[ExchangeRate], 1 ), FactCurrenciesCourses[Date] <= d, CROSSFILTER ( 'Calendar'[Date], FactCurrenciesCourses[Date], NONE ) )
Check-out these instructions to determine which of the two solutions will work best for you. Both solutions posted here are industry best.
@Anonymous,
Drag [Date] from Calendar table and add measure below.
Measure = VAR d = SELECTEDVALUE ( 'Calendar'[Date] ) RETURN CALCULATE ( LASTNONBLANK ( FactCurrenciesCourses[ExchangeRate], 1 ), FactCurrenciesCourses[Date] <= d, CROSSFILTER ( 'Calendar'[Date], FactCurrenciesCourses[Date], NONE ) )
Appreciated, Sam!
Thank you very much!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |