Forum Discussion

Pezir's avatar
Pezir
Frequent Visitor
7 years ago

Create column, Display Data from another column if current month, otherwise blank

Hi!   I try to explain this. :manvery-happy: I would like to create a new column which shows data from another column (sales) IF that sale has happened in current month OTHERWISE blank cell. ...
Need Help
Pezir's avatar
Pezir
Frequent Visitor
7 years ago

venug20
Maybe this picture will help. Lets imagine that CurrentMonth is 9th. I would like to create New Column which shows only data from CurrentMonth.

 



I have also created a IsCurrentMonth column in calendar if we can use that. 

 

Thank you!

venug20's avatar
venug20
Resolver I
7 years ago

Pezir

 

Please look into this formula, it may helps you...

 

Datef = IF(CurrentMonth[Date] < [SM] , BLANK(), CALCULATE(SUM(CurrentMonth[Sales]),  DATESBETWEEN(CurrentMonth[Date], [SM], MAX(CurrentMonth[Date]))))

 

 

When i try to your reuqirement, as you mention above like "Blank".... 

it throughs error, why because not retrun text and calculation as well as.

 

see error below...

 

 

 

It it is solution to your query. Please accept as a solution, it is helpful to others.....

 

  • venug20's avatar
    venug20
    Resolver I
    7 years ago

    Pezir

     

    i forgot to provide SM Formula...

     

    SM = DATE(YEAR(TODAY()), MONTH(TODAY()), 1)

    • Pezir's avatar
      Pezir
      Frequent Visitor
      7 years ago

      Thank you venug20 I will try this later.