Forum Discussion

htittoto's avatar
htittoto
Frequent Visitor
6 years ago
Solved

CountIfs by past data

  Hello,   could someone help me? I'm trying to built a column in power query to count how many times have I made a sale and, most importantly, what sale (order by brand and date) was that. ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    you mjust load you data and goes unde view/advance editors panel in PBI (I understood you use PBI, is it true?).

     

     

    inside this panel cut and paste the lines of code you find in my post.

    edit and modify so that you have a situation like this:

     

     

     

     

    that is all.

     

     

htittoto's avatar
htittoto
Frequent Visitor
6 years ago

Thanks for replying Anonymous ,

 

unfortunately, I couldn't quite understand how to implement it, I believe I'm not that advanced in PBI yet. Could you please explain step-by-step how to implement it a little bit more, please?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

you mjust load you data and goes unde view/advance editors panel in PBI (I understood you use PBI, is it true?).

 

 

inside this panel cut and paste the lines of code you find in my post.

edit and modify so that you have a situation like this:

 

 

 

 

that is all.

 

 

  • htittoto's avatar
    htittoto
    Frequent Visitor
    6 years ago

    Thanks Anonymous !