Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

WORKING WITH DATES

Hi Everybody,   I have a challenge for you guys. In my dataset I have a column with dates.   Then, in my report I need to create a kpi about last 3 months sales (excluding current month). I was t...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

    There could be other smart approaches too, but just to answer your question,

     

    1. Create a new column with this formula :

     

    last_Month=IF( AND(MONTH(Sheet1[Date])=MONTH(TODAY())-1,YEAR(Sheet1[Date])=YEAR(TODAY())),Sheet1[Sales],0)

     

    2. Create a new measure with this formula:

     

    Sales_Lastmonth= SUM( Sheet1[last_Month]

     

    This will fetch you last month sales. You can do similarly for other months too.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

There could be other smart approaches too, but just to answer your question,

 

1. Create a new column with this formula :

 

last_Month=IF( AND(MONTH(Sheet1[Date])=MONTH(TODAY())-1,YEAR(Sheet1[Date])=YEAR(TODAY())),Sheet1[Sales],0)

 

2. Create a new measure with this formula:

 

Sales_Lastmonth= SUM( Sheet1[last_Month]

 

This will fetch you last month sales. You can do similarly for other months too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    That works perfeclty! However i'm curious about the other smart ways you can get this value. Any ideas?