Forum Discussion

zawlh's avatar
zawlh
Icon for Helper I rankHelper I
6 years ago

Calculate % change from previous column

Hello everyone, I am new to Power BI. We used Postgres data from our chatbot system.  So this is our chatbot result. I would like to calculate % change with line value showing how many % of user...
zawlh's avatar
zawlh
Icon for Helper I rankHelper I
6 years ago

az38  I am sorry. Because of my bad English writing, I think you misunderstand something. I want X-axis to be Day Number(day01-begin,day01-end,day02-begin,.....). The percent change I want is how many percent of users have dropped from day01 to day02 to day03 to ........

Thanks for your patience and guiding. 
I hope you can help me with this.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

zawlh 

look here https://ufile.io/lvak35gl 

simple example which looks like you need (as I think)

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • zawlh's avatar
    zawlh
    Icon for Helper I rankHelper I
    6 years ago

    az38  Bro your formula makes some progress. But I still have some problems. Could you help with me please. My measure show only 0%
    . 
    I used the same exact formula with yours, using my original table name.