Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculating percentage change through time

Hi I am new to PowerBi and I have a data set with two columns: date and action type(ABC, DEF, GHI). I am interested to find the percent change in the ABC action type through the years with the foruml...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous ,

     

    You may try adding measure below.

    Measure =
DIVIDE (
    COUNTROWS ( FILTER ( Table1, Table1[type] = "ABC" ) ),
    COUNTROWS ( FILTER ( Table1, Table1[type] IN { "DEF", "GHI" } ) )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

You may try adding measure below.

Measure =
DIVIDE (
    COUNTROWS ( FILTER ( Table1, Table1[type] = "ABC" ) ),
    COUNTROWS ( FILTER ( Table1, Table1[type] IN { "DEF", "GHI" } ) )
)