Forum Discussion

sherrieg's avatar
sherrieg
New Member
8 years ago

Sales Placement Count

I'm very new with Power BI, so I was hoping someone could help with this. I'm trying to build a report that will track new sales placements of an item (within a certain time period). How would I go about that?

 

As an example: Accounts that purchased an item in March, but not in January & February.

 

Thank you in advance!!

2 Replies

  • pbiozkan's avatar
    pbiozkan
    Helper I
    8 years ago

    Hi,

     

    Add date slicer and select only "March", put another slicer for year if you need too. You can add visual level filter or report level filter for the month you want too, but if you add March to report level filter, you'll only see March data on your whole report. 

     

     

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi sherrieg,

     

    Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue?

     

    It's better to just share a dummy pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards