Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combine Slicer (Date from...until...) and function 'prevoiusmonth'

Hi folks,   i have a question about slicers and the function „previousmonth“. I calculated flexitime (starts in 2003 until today). I use a date slicer, which shows date from (2003-01-01) until date...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for your answer RobbeVL!

     

    I found an answer:

     

    Flextime last month =CALCULATE([flextime];DATEADD(Calendar[Date];-1;MONTH))
RobbeVL's avatar
RobbeVL
Icon for Impactful Individual rankImpactful Individual
6 years ago

Hi,

When you use PREVIOUSMONTH, it actually returns the value of the complete previous month.

The function Previousmonth on a day level does not exist. This is because the different of numbers of days per month differs. 

 

What is your expected output wheb you want last month of 30/03/2019

 

Also I dont know what your data is about, but comparing the monthnumbers is usually not very insightfull. 

Try having a look at weeknumbers ? 

 

Although it is not impossible to create what you requested.

 

Have a look here:


https://community.powerbi.com/t5/Desktop/PREVIOUSMONTH/td-p/13307

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your answer RobbeVL!

     

    I found an answer:

     

    Flextime last month =CALCULATE([flextime];DATEADD(Calendar[Date];-1;MONTH))