Forum Discussion

Rosebud's avatar
Rosebud
New Member
9 years ago
Solved

subtract if

Hi All,    I need help figuring something out in Power BI.    I am using the matrix visualization.    I have a column I created that shows either Pre Test, Test, or Post Test based on week numb...
Need Help
  • Rosebud's avatar
    Rosebud
    9 years ago

    I figured it out if anyone were to need help with this in the future.

     

    Group 1 Delta = Calculate([Group 1 Metric],filter('Dataset name','Dataset name'[StatusColumn]="time frame"))-Calculate([group 1 delta],filter('Dataset name','Dataset name'[StatusColumn]="time frame"))

Rosebud's avatar
Rosebud
New Member
9 years ago

I figured it out if anyone were to need help with this in the future.

 

Group 1 Delta = Calculate([Group 1 Metric],filter('Dataset name','Dataset name'[StatusColumn]="time frame"))-Calculate([group 1 delta],filter('Dataset name','Dataset name'[StatusColumn]="time frame"))