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 mon...
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