Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to fill the gaps in values between dates

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-Ra...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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 )
    )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

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 )
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Appreciated, Sam!
    Thank you very much!