Forum Discussion

shamim20's avatar
shamim20
New Member
6 years ago
Solved

Calculated column based on two other column

Hello altruists,  Need some help here. I have 3 columns of data with millions of rows ( File, record and Time). Each file may have multiple records. Would like to create 4 new columns calculating t...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    shamim20 add four measures, here is example of 0 - 1

     

    Diff 0 to 1 = 
VAR __filter = ALLEXCEPT ( 'Table', 'Table'[File] )
VAR __valStart = CALCULATE ( [Sum], __filter, 'Table'[Record] = 0 )
VAR __valEnd = CALCULATE ( [Sum], __filter, 'Table'[Record] = 1 )
RETURN
__valStart  - __valStart

     

     

shamim20's avatar
shamim20
New Member
6 years ago

Hi,

Thanks for your reply. What are you referring to as sum here >>

[Sum]

 

shamim20's avatar
shamim20
New Member
6 years ago

This is what I ahve at the end

 

Diff 0 to 1 = 
VAR __filter = ALLEXCEPT ( 'Table', 'Table'[File] )
VAR __valStart = CALCULATE ( SUM(TABLE.Time), __filter, 'Table'[Record] = 0 )
VAR __valEnd = CALCULATE ( [SUM(TABLE.Time),__filter, 'Table'[Record] = 1 )
RETURN
__valStart  - __valStart