Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Current Year Sales

Hello all,
 
I am currently stuck with calculating the sales of current year Sales.
So the goal is to show a line graphic that shows sales data from 1 januari of 2019 until 9 januari 2019. On this Power BI report page a user must not filter any visuals..
 
My current measure Current Year Sales is as below:
 
Current Year Sales = CALCULATE(SUM('Sales invoice line'[Line amount MST]);
YEAR('Dim Calender Sales Invoice'[FullDateAlternateKey])=YEAR(TODAY()))
 
 
Any suggestions?
 
Thank you 
Need Help
Show and Tell
Tips and Tricks
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

     

    Regards,

    Daniel He

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    You can create a calculate column in 'Dim Calender Sales Invoice' :

    IsCurrentYear =
VAR TodayDate =
    TODAY ()
VAR CurrentYear =
    YEAR ( TodayDate )
RETURN
    'Dim Calender Sales Invoice'[FullDateAlternateKey]
    >= DATE ( CurrentYear, 01, 01 )

    Then the following measure:

    Current Year Sales =
VAR Temp =
    CALCULATE (
        SUM ( 'Sales invoice line'[Line amount MST] ),
        'Dim Calender Sales Invoice'[IsCurrentYear] = TRUE ()
    )
RETURN
    IF ( Temp = BLANK (), 0, Temp )

     Best Regards

    Chiara

     

  • affan's avatar
    affan
    Icon for Solution Sage rankSolution Sage
    7 years ago

    hi Anonymous

     

    Can you please elaborate a little more what you are trying to acheive. As per your post above, the measure is correct and shows the current year sales only.

     

    So what is the probelm?

     

    Thanks & Regards

    Affan

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi affan,

      The measure is correct indeed. but the when i display this on a table

       

      The result is now

       

      date 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Year               Sales
        2016        560.000
        2017        560.000

        2018        560.000

        2019        560.000

         

        I expect the following table result

         

        Year           Sales
        2016        0
        2017        0

        2018        0

        2019        560.000

         

         

        So how can i get this result based on my current measure of Current Year Sales

         

        Current Year Sales = CALCULATE(
        SUM('Sales invoice line'[Line amount MST]);
        YEAR('Dim Calender Sales Invoice'[FullDateAlternateKey])=YEAR(TODAY()))
         
  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

     

    Regards,

    Daniel He