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

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