Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Value spread over a date range

Hello good afternoon.   I'm finding it difficult to find a measure that brings me a value divided over a range of dates, based on just one row in a fact table. I explain: I have the following data:...
lbendlin's avatar
lbendlin
Super User
5 years ago

You don't really have dates to work with, you have months. (Is it just me or is the month count off? Shouldn't it be 13?)

 

Either you create fake date values (first of month) or you do your computations without a calendar table. I would prefer the former approach.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

Actually, it was 13 months, I rectified the date. I didn't quite understand the first solution. As far as I can already extract the month from the date. In addition, there is another rule where if the date is after the 28th of the month, the apportionment will start the following month.

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Then you definitely need a custom Calendar/Dates table. It can be maintained externally (for example an Excel file on a sharepoint) and then consumed as a data source in Power BI.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      OK, I can't visualize the solution, would you like to exemplify?