Forum Discussion

MS2121's avatar
MS2121
Regular Visitor
5 years ago
Solved

Splitting quarterly sales

Hi all   I have a sql Server Database with different tables including item codes, item groups and Sales.    Some articles are being invoiced at the beginning of a quarter in advance.  The sales a...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, MS2121 

    I have created a sample data by myself to demonstrate your question.

    Please kindly correct me if I wrongly understood.

    I believe there are some differentiation codes between normal sales and early sales.

    I added normal sales as usual.

    I added early sales as per your inquiries.

    Please kindly have a look at the below link, which is the sample pbix file.

     

    I hope it helps.

     

    https://www.dropbox.com/s/sg1x4ilbxvaim0u/ms2121%202021%200326.pbix?dl=0 

     


    Did I answer your question? Mark my post as a solution!

    Appreciate your Kudos!!

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, MS2121 

I have created a sample data by myself to demonstrate your question.

Please kindly correct me if I wrongly understood.

I believe there are some differentiation codes between normal sales and early sales.

I added normal sales as usual.

I added early sales as per your inquiries.

Please kindly have a look at the below link, which is the sample pbix file.

 

I hope it helps.

 

https://www.dropbox.com/s/sg1x4ilbxvaim0u/ms2121%202021%200326.pbix?dl=0 

 


Did I answer your question? Mark my post as a solution!

Appreciate your Kudos!!