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!!

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

MS2121 , I have few articles to deal with , they are for month, year and Range. But should be able use those to get one for quarter

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

 

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400

 

Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798