Desktop

[regasanyoto]

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 

[v-danhe-msft · Accepted solution]

Hi @regasanyoto,

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

[affan]

hi @regasanyoto

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

[regasanyoto]

Hi @affan,

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

The result is now

date 

[regasanyoto]

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()))

[Chiara]

Hi @regasanyoto,

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

[v-danhe-msft]

Hi @regasanyoto,

Based on my test, this measure could work on my side:

Could you please offer your data to have a test? Also you could download my pbix file to have a view.

Regards,

Daniel He

Current Year Sales.pbix

[v-danhe-msft · Accepted solution]

Hi @regasanyoto,

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