DAX "SUMIFS" two criterias

[espendl]

Hi 

I am new to power pivot and power bi.

I want to make a calculated column that sum a column (same table) if two criterias are met - combination of two values in their respective columns.

All values are in the same table, however I also have two dimension tables if it helps. E.g. in the picture below.

Regards,

Espen

[espendl]

Hi 

I am new to power pivot and power bi.

I want to make a calculated column that sum a column (same table) if two criterias are met - combination of two values in their respective columns (Name (NameID) and Date)

All values are in the same table, however I also have two dimension tables if it helps. E.g. in the picture below.

Regards,

Espen (from Norway, sorry for the bad explanation

[Ashish_Mathur]

Hi,

Try these calculated column formulas

Col1=CALCULATE(SUM(Data[Numbers]),FILTER(Data,Data[Name]=EARLIER(Data[Name])&&Data[Date]=EARLIER(Data[Date])))

Col2=[Numbers]/[Col1]

Hope this helps.

[Zubair_Muhammad]

Hi @espendl

Try this column

=
CALCULATE (
    SUM ( Table1[Numbers] ),
    ALLEXCEPT ( Table1, Table1[Name], Table1[Date] )
)