Forum Discussion

MEverts's avatar
MEverts
Frequent Visitor
6 years ago
Solved

DAX Measure for Active Subscribers not plotting in Excel

Dear,    I'm looking to plot the number of Open and Answered data-entry queries in Excel using a dax patern for active subscribers/tickets.     My Source data looks like this, together with a dis...
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi MEverts 

     

    You can use 

    VAR _CurrDate =
    MAX( 'Calendar'[Date] )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

MEverts's avatar
MEverts
Frequent Visitor
6 years ago

Dear Mariusz,

Thank you so much!! It works:-)

Best regards,


Martijn

 

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi MEverts 

 

No problem, happy to help!

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn