Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |