Forum Discussion

cyborgandy's avatar
cyborgandy
Helper II
2 years ago
Solved

DAX for same number

Hi All,

 

I have below dataset in my power bi dax, I want to write a dax for new column which should give matched or unmatched text in new column, I want new columns to match month and company name along with the spend. I want - vlaue to matched with +ve value for same company and month

 

MonthCompanySpendValidation
JanABC-5000Matched
FebABC4000Unmatched
JanABC5000Matched
FebABC5000Unmatched
JanXYZ-1000Matched
FebXYZ2000Unmatched
JanXYZ-1000Matched
FebXYZ3000Unmatched
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    HI, cyborgandy 

    try below code for new column 

     

    Column = 
var a = 'Table'[Month]
var b = 'Table'[Company]
var c = ABS('Table'[Spend])
var final= CALCULATE(
                COUNTROWS('Table'),'Table'[Month]=a,'Table'[Company]=b,ABS('Table'[Spend])=c
            )
return
IF(final=1,"unmatched","matched")

     

     

     

3 Replies

    • cyborgandy's avatar
      cyborgandy
      Helper II
      2 years ago

      Expected outcome column is already added as Validation column the snapshot I mentioned

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    HI, cyborgandy 

    try below code for new column 

     

    Column = 
var a = 'Table'[Month]
var b = 'Table'[Company]
var c = ABS('Table'[Spend])
var final= CALCULATE(
                COUNTROWS('Table'),'Table'[Month]=a,'Table'[Company]=b,ABS('Table'[Spend])=c
            )
return
IF(final=1,"unmatched","matched")