Forum Discussion

DeepakJha23's avatar
DeepakJha23
Helper I
4 years ago
Solved

Dynamically grouping based on date selection in slicer

Hi Power BI Community,   I need some help with the dynamic grouping of data based on slicer selection.   I am using the week_end_date as slicer and I am showing the card of response yes and...
Need Help
Tips and Tricks
  • nvprasad's avatar
    nvprasad
    4 years ago

    Hi Deepak,

    You can try with below DAX

    result = 
    Var selectedweekendMonth = EOMONTH(SELECTEDVALUE(Week_End_Date),-1)+1

    Retrun CALCULATE(COUNTROWS(RESPONSES),CALANDER[MONTH] = selectedweekendMonth , RESPONSE = "Yes")

    Appreciate a Kudos! ‌‌
    If this helps and resolves the issue, please mark it as a Solution! ‌‌

    Regards,
    N V Durga Prasad

     

nvprasad's avatar
nvprasad
Solution Sage
4 years ago

Hi Deepak,

You can try with below DAX

result = 
Var selectedweekendMonth = EOMONTH(SELECTEDVALUE(Week_End_Date),-1)+1

Retrun CALCULATE(COUNTROWS(RESPONSES),CALANDER[MONTH] = selectedweekendMonth , RESPONSE = "Yes")

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

 

  • DeepakJha23's avatar
    DeepakJha23
    Helper I
    4 years ago

    nvprasad Thanks for the solution. It worked .