Forum Discussion

gopichilla's avatar
gopichilla
Resolver III
9 years ago
Solved

How to solve this one

I have created derived measure based on the due date using NextDay and NextMonth functions in DAX.   I have a data in next day and next month.   I am using this query    Next Month Due Task = C...
Need Help
  • EvertonPessoa's avatar
    EvertonPessoa
    9 years ago

    Hello Gopichilla, If your base date is today, you can use the following measures:

     

    NEXT_DAY = CALCULATE(COUNTA('All Projects Tasks'[Tasks]); 'All Projects Tasks'[Due Date] = TODAY() + 1)
					
NEXT_MONTH = CALCULATE(COUNTA('All Projects Tasks'[Tasks]);MONTH('All Projects Tasks'[Due Date]) = MONTH(TODAY()) + 1)
EvertonPessoa's avatar
EvertonPessoa
Helper I
9 years ago

Hello Gopichilla, If your base date is today, you can use the following measures:

 

NEXT_DAY = CALCULATE(COUNTA('All Projects Tasks'[Tasks]); 'All Projects Tasks'[Due Date] = TODAY() + 1)
					
NEXT_MONTH = CALCULATE(COUNTA('All Projects Tasks'[Tasks]);MONTH('All Projects Tasks'[Due Date]) = MONTH(TODAY()) + 1)
gopichilla's avatar
gopichilla
Resolver III
9 years ago

Thanks EvertonPessoa

 

It is working fine.