Forum Discussion

trungduc5900's avatar
trungduc5900
Frequent Visitor
8 years ago

Auto generate column when meet a condition

 Hi there, 

 

I'm very new to the Power BI. 

 

Currently, I have a data set that content 2 column "Begin date" and "End date". I want to create multiple column which count number of date each month from "Begin date" to "End date", example as below:

 

 

 

 

Thank you in advance for your help.

 

 

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi trungduc5900,

     

    Are there other columns like values in your table? And are there seperate values in each month in your table? Can you create a sample table with some dummy data for further analysis?

     

    Regards,

    Jimmy Tao

    • trungduc5900's avatar
      trungduc5900
      Frequent Visitor
      8 years ago

      Hi Jimmy,

       

      Many thanks for your reply 

       

      Basiccally, i was trying to allocate Contract value by month based on contract's duation. So i have a table with the following detail:

      1. Customer name

      2. Contract value

      3. Contract begin date 

      4. Contract end date.

       

      The sample table would look like this 

       

       

       

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Hi trungduc5900 ,

         

        Could you clarify your logic about how to achieve allocate Contract value by month?

         

        Regards,

        Jimmy Tao