Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Inflation calculation

    Gold Contributor
    Posted Oct 31, 2022 06:39 AM
    Hi All, I have an inflation table against each area, country.
    On each anniversary date (i.e. Rate start + 365days) I wanted to add the inflation of 3% to Rate start or ever is indicated in the inflation table.

    Pls help in doing by DAX



    ------------------------------
    FA
    ------------------------------


  • 2.  RE: Inflation calculation

    Posted Oct 31, 2022 12:44 PM
    @Vinu Hari,
    Could you share a .pbix file with some sample data, so that we can better understand the data model?  I am not sure what tables you have available, so it's very hard to suggest a DAX solution without knowing the structure of your dataset.

    Kaz.​

    ------------------------------
    Kaz Shakir
    Sr. Program Manager, Asset Planning
    TN
    ------------------------------