Forum Discussion
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...
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
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
Hi trungduc5900 ,
Could you clarify your logic about how to achieve allocate Contract value by month?
Regards,
Jimmy Tao
