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...
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

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

        zawlh 

        try a measure like this

        Measure = 
var _currentContextDay = DATE(YEAR(SELECTEDVALUE('Table'[timestamp]));MONTH(SELECTEDVALUE('Table'[timestamp]));DAY(SELECTEDVALUE('Table'[timestamp])))
var _countCurDay = CALCULATE(DISTINCTCOUNT('Table'[messenger_id]);FILTER(ALL('Table');'Table'[timestamp].[Date]=_currentContextDay))
var _countLastDay = CALCULATE(DISTINCTCOUNT('Table'[messenger_id]);FILTER(ALL('Table');_currentContextDay=DATEADD('Table'[timestamp].[Date];1;DAY)))
return 
1-DIVIDE(_countLastDay;_countCurDay)

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