Forum Discussion

Kopek's avatar
Kopek
Icon for Helper IV rankHelper IV
6 years ago
Solved

Dax Time ineligence measure issue

Hi Everyone!   I do have a problem with creating a proper DAX measure. I have created DAX calendar, where relationship to my Manager Raitings tab is done. Based on that calendar i extracted Quart...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Kopek 

     

    Try something like this:

    3Mth = calculate(COUNT('Manager Ratings'[Status]),DATESINPERIOD('Calendar'[Date],max('Calendar'[Date]),-3,MONTH))

     

    if not help, please kindly share yor dummy pbix.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Kopek , for rolling try like

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-12,MONTH))
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],max(Sales[Sales Date]),-12,MONTH))  
Rolling 12 till last 12 month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(dateadd(Sales[Sales Date],-12,month)),-12,MONTH))

Rolling 3= CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],staroffmonth(Sales[Sales Date]),3,MONTH))

Rolling 7 days = CALCULATE(sum(Sal[Sales Amount]),DATESINPERIOD('Date'[Date],max(Sales[Sales Date]),-7,Day))