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


     

Mariusz's avatar
Mariusz
Community Champion
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
    Community 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