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

 

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

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