Forum Discussion

UditJ's avatar
UditJ
Icon for Helper III rankHelper III
3 years ago

Need to perform a quick table calculation - "Difference" from tableau in Power BI

Need to subtract campaign B  value - Campaign A value  and so on..See the beloe screenshot :



any idea how to do this in power bi ? 

Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    UditJ , In power bi visual row/table calculations are not supported.

     

    You need to have a rank or sort order for campaigns ( preferably campaign should be dimension)

     

    New column

     

    Rank = rankx(campaign , campaign[Name],,asc, dense)

     

    This campaign = calculate([measure] , filter(all(campaign), [Rank] = Max([Rank]) ) )

    Last campaign = calculate([measure] , filter(all(campaign), [Rank] = Max([Rank]) -1  ) )

     

     

    same as Week on Week

     

    Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
    Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s