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  the number is the distinctcount of messengerID. I want percent difference from previous column(column from chart). (For eg. 38% drop from day01-begin to day01-end (assuming day01-begin is 100%). Could you solve it ?

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

zawlh 

its still not almost clear but try to create a measure like

Measure = 
var _prevDayNumberStart = CALCULATE(MAX('Table'[Day Number]), FILTER(ALL('Table'), 'Table'[timestamp] < SELECTEDVALUE('Table'[timestamp]) && CONTAINSSTRING('Table'[Day Number],"begin"))
var _prevDayTimestamp = CALCULATE(MAX('Table'[timestamp]), 'Table'[Day Number]=_prevDayNumberStart)

RETURN
DIVIDE( CALCULATE(DISTINCTCOUNT('Table'[messenger_id]), FILTER(ALL('Table'), 'Table'[timestamp] < SELECTEDVALUE('Table'[timestamp])), CALCULATE(DISTINCTCOUNT('Table'[messenger_id]), FILTER(ALL('Table'), 'Table'[timestamp] < _prevDayTimestamp) )

not sure, it will work, need to check 

 

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