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.

I have created the calendar which has a data "IsCurrentMonth" = 1, if helps.

 

Goes too complicated for my brains, would appreciate your help. Thanks!

Need Help

6 Replies

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