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 will show you database
I cannot use the formula you provide unless you don't know exactly about my data 

sorry for confidential data

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

zawlh 

distinct count of users should be calculate for a day or for the whole period before the day?

 

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  for each day. And I want to see how many percent of users have dropped. Day Number is just alternate name of attribute. There are too many attribute in chatbot. But I only need some attribute and I have to change the name with another column 

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

      zawlh 

      and how do you calculate count of users in day-begin point?

       

      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  I used Day Number is X-axis and DISTINCTCOUNT of messenger_id in value(so not difficult). What makes me difficult is the percent change in each day

        The above graph is the example