Forum Discussion

homelander123's avatar
homelander123
Helper I
1 year ago
Solved

DAX Query Not working

PMPCCountNew = Var SelectedDate = SELECTEDVALUE(Query1[CSMDate]) Var PrevMonthStart = EOMONTH(SelectedDate, -2) +1 Var PrevMonthEnd = EOMONTH(SelectedDate,-1) RETURN IF( NOT ISBLANK(SelectedDate...
"DAX "
"DAX " "DAX help" 'Need help'
"DAX " "DAX help" 'Need help' 'DAX'
"DAX Commands and Tips"
"DAX help"
"DAX help" 'Need help' 'DAX'
  • maruthisp's avatar
    maruthisp
    1 year ago

    Hi homelander123 ,

    Please find the attached pbix file for your solution.
    What it does below:

    1. use ALLEXCEPT(Query1,Query1[CSMDate]) inside CALCULATE so you keep the slicer’s filter but drop everything else
    2. Measure - dynamically computes the prior-month window and sums PCCount across it

    CSMDate and ICM Date.pbix

    Please let me know if you have further questions.

    If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

     

    Best Regards, 

    Maruthi 

    LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

    X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi homelander123 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.