Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Nextmonth calculation

Hi, This is my table.I just want to calculate Aug month total hours value. I used this measure  Next month value = calculate(sum('table'[total hours value]),dateadd(table[month year],+1,mont...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , This wrong usgaes. If you need just to diaply next month use this 

    next month = format(eomonth(today(),1),"MMM-YYYY")

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Pragati..its not working

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can you help me to calculate the next month measure alone.

 

ans should be "Aug 2020".

 

i tried Next month = month(today()+1)

the ans was "8"..but i need Aug 2020

 

Thanks

Kg

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    You can use following measure to get next month value:

    Next month = DATEADD(ClothingSales[Date], 1, MONTH)
     
    Replace ClothingSales[Date]  in above dax with your date column.
     
    Also, please try tagging people you are trying to respond from next time.
     
    Thanks,
    Pragati
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi

      this is my actual problem.

      Thanks

      Kg

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        Anonymous , That is wrong, why are you using month year in dateadd function. 

        you need to use date. Same has been provided in all formulas 

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    6 years ago

    You cannot use DateAdd with Measure....

    You need to create calculated column to get the next month Value.

     

    Create a new Table name it "Date" using "CalendarAuto()"

     

     

    Now Join this date with your  Table (MonthYear and Date)

     

    Mark this new date table as "Date Table"

     

     

    Create measure to calculate next month value

    Next month value = calculate(sum('table'[total hours value]),DATESINPERIOD(DimDate[Date],MAX(DimDate[Date]),1,MONTH))