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
venug20's avatar
venug20
Resolver I
7 years ago

Pezir

 

Can you provide sample data for your quiery.... 

  • 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!

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      7 years ago

      Pezir,

       

      You may just add measure below.

      Measure =
CALCULATE ( SUM ( Table1[Sales] ), 'Calendar'[IsCurrentMonth] = 1 )
    • 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)