Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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,
Please see if my solution here helps - Distribute projected revenue annually.
Hi trungduc5900 ,
Could you clarify your logic about how to achieve allocate Contract value by month?
Regards,
Jimmy Tao
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
62 | |
61 |