Calculating Differences

[MRadaci]

Hello, 

Pardon my ignorance, but I am in need of some direction/assiatnce. I have a table that I need to calculate the difference of the daily_%_total by column "dialer" (has 2 values, N and U) and column "dt". 

Is this possible within Power BI? I have tried filtering, grouping as well as allexcept without any success.

Source table:

Desired Result:

Any assitance is greatly appreciated. 

[Anonymous]

HI @MRadaci,

It will be help if you share sample data/pbix file for test.

In addition, if you mean create dynamic column/table from slicer/filter, current power bi not support this, please use measure to instead.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,

Xiaoxin Sheng

[MRadaci]

Hi Xiaoxin!

Thanks for your response. I have attached a sample dataset (xls).

The goal is for a sliced date, compare difference in systems (N vs. U) for each category's %.

 

Thanks for any assitance you can provide.

https://github.com/AFC1886/SampleData/blob/master/Example%20Data.xlsx

[Anonymous · Accepted solution]

Hi @MRadaci,

You can try to use below formula to show diff on total level.

Diff =
IF (
    ISFILTERED ( Sheet1[system] ),
    SUM ( Sheet1[daily_%_total] ),
    CALCULATE ( SUM ( Sheet1[daily_%_total] ), Sheet1[system] = "N" )
        - CALCULATE ( SUM ( Sheet1[daily_%_total] ), Sheet1[system] = "U" )
)

Regards,
Xiaoxin Sheng

[MRadaci]

Hi @Anonymous, 

I just wanted to say thanks for your assitnace. It was very helpful. What a great community!