Forum Discussion

parladdhungana2's avatar
parladdhungana2
New Member
2 years ago

Power BI Dax

I have a data set with multiple columns with "Part Number" and "Date."
I want to add a new column using DAX
If [part number] is present in this quarter and the previous quarter then print that [part number], otherwise print blank or null

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    parladdhungana2 ,

    Try like

     

    Present in both Qtrs=
    var _max1 = [Date]
    var _lmax = eomonth(_max1,-1* if( mod(Month(_max1),3) =0,3,mod(Month(_max1),3)))
    var _lmin = eomonth(_lmax,-3)+1
    var _min = eomonth(_max1,-1* if( mod(Month(_max1),3) =0,3,mod(Month(_max1),3)))+1
    var _max= eomonth(_min, 2)
    return
    if(
    not(isblank(countx(filter(Table, [Part Number] = earlier([Part Number]) && [Date] >= _lmin && [Date] <= _lmax), [Part Number])))

    &&

    not(isblank(countx(filter(Table, [Part Number] = earlier([Part Number]) && [Date] >= _min && [Date] <= _max), [Part Number]) )) , [Part Number], blank())