Add a static number to a particular date

[FurqanTilad_3]

Hi Everyone,

I have just recently started to use Power BI. I have a data set of numbers that are quarterly, and i am trying to add an aggregated number (filtered between Q3 and Q4), say a number at 12/31/2021, to a series of Cash Flows and then use the XIRR function to calculate the IRR.

Now the cash flow series has a series of cash flows that are almost daily, and i want my static number to be added to this series at a very specific date (12/31/2021). 

Thanks.

[Anonymous]

Hi @FurqanTilad_3 ,

Does your dataset with static numbers also have corresponding dates?

If there is, you could try to create a relationship between the dates of the two tables.

You can directly add static numeric columns to the visual because of the existence of relationships.

Or you could add a calculated column in the main table.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@FurqanTilad_3 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer if this can help

https://www.youtube.com/watch?v=N1WRSFuaFmE&t=10s