Forum Discussion

DJKarma's avatar
DJKarma
Frequent Visitor
3 years ago
Solved

Get Count in Query Editor by 2 Columns

I have to create such a column in PowerBI Query Editor   This is the base table -- Customer ID Unit ID Date  Stamped 1 XX 1st jan 1 1 YY 1st jan 2 1 XX 2nd jan 2 1 YY ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi DJKarma ,

    Please have a try.

    Create a measure.

    Measure = calculate(SUM('Table'[STAMPED]),FILTER(ALL('Table'),'Table'[DATE]=SELECTEDVALUE('Table'[DATE])&&'Table'[customer is]=SELECTEDVALUE('Table'[customer is])))

    Or a column.

    Measure = calculate(SUM('Table'[STAMPED]),FILTER(('Table'),'Table'[DATE]=EARLIER('Table'[DATE])&&'Table'[customer is]=EARLIER('Table'[customer is])))

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi DJKarma ,

How about this?

List.Sum(Table.SelectRows(#"Added Custom2", (x)=>x[Year]=[Year] and x[month]=[month] and x[day]=[day] and x[customer is]=[customer is])[STAMPED])

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DJKarma's avatar
DJKarma
Frequent Visitor
3 years ago

Thanks, for editing, as i am learning.

List.Sum(Table.SelectRows(#"Added Custom2",

 

When i put this query , it says Custom2 was not recognized, I am assuming I did extract columns from date and renamed to look exactly like yours. And my last instance was Renamed Columns. So shall i put it as--

 

List.Sum(Table.SelectRows(#"Renamed Columns", (x)=>x[Year]=[Year] and x[month]=[month] and x[day]=[day] and x[customer is]=[customer is])[STAMPED])

?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi DJKarma ,

    You are right. The red mark in the formula represents the previous step of the present step.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.