Forum Discussion

Balazs_POL's avatar
Balazs_POL
Regular Visitor
6 years ago
Solved

Current year measure problem

Hello Everybody,   First of all I would like to tell you that I have started the learning of the PowerBI desktop application and I am a newbie user (yet). I have tried to find the solution or the s...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

     Hi Balazs_POL ,

     

    We can try to use the following DAX to see if it meet your requirement.

     

    2019_NET_SALES = IF (
    YEAR ( SELECTEDVALUE ( 'TRANSACTION'[INVOICE_ISSUE_DATE] ) ) = YEAR ( TODAY () ),
    [TOTAL_SALE],
    BLANK ()
)

     

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ DongLi
    If this post helps, then please consider Accept it as the solution to help the other members find it more

Balazs_POL's avatar
Balazs_POL
Regular Visitor
6 years ago

Hello v-lid-msft,

 

Thank you for your response. Exactly what I would like to do to get a measure which only sum the 2019 daily sales. I updated your file on the way how my file looks like. I put a text box exactly next to the row which is missing. :) 

 

File is available here: Current-year-measure-problem_Balazs

 

Thank in advance.

 

Kind regards,

Balazs

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

 Hi Balazs_POL ,

 

We can try to use the following DAX to see if it meet your requirement.

 

2019_NET_SALES = IF (
    YEAR ( SELECTEDVALUE ( 'TRANSACTION'[INVOICE_ISSUE_DATE] ) ) = YEAR ( TODAY () ),
    [TOTAL_SALE],
    BLANK ()
)

 

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more

  • Balazs_POL's avatar
    Balazs_POL
    Regular Visitor
    6 years ago

    Hello v-lid-msft,

     

    Thank you for your help, it is fine. :)

     

    Balazs