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")

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

Hi Anonymous ,

 

Create a measure as follows:

next month sales = CALCULATE(SUM(ClothingSales[Sales]), DATEADD(ClothingSales[Date], 1, MONTH))
 
Just use your dates column in above dax.
 
Thanks,
Pragati
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Pragati..its not working

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    Your comment - Not working doesn't give me any insight on what is wrong with it.

    Always helpful to have some screesnhot with error.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Its still showing July values not aug values

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

        Anonymous , Few things.

        1) Your data table should be marked as a date table.

        2. Hope Jul 2020 is the month on the page. If not then time intelligence will pick up last month of the calendar

  • 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
      Icon for Super User rankSuper 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

    • FarhanAhmed's avatar
      FarhanAhmed
      Icon for Community Champion rankCommunity 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))