Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hello everyone,
I have a dataset where there are two date columns and I would like to achieve the following from these columns:
I would like to show how many workflows started per month in a given year. In this dataset, there is no unique ID column and when I tried to solve it it shows the workflows started/ended per month same although they are different.
I tried the following:
1. Create a separate calendar table to create relationships, then insert the date columns in the bar chart and use the date from the calendar table.
2. Create a measure to count only started or ended workflows in each column and apply them in the bar chart.
3. Unpivoting the columns which works but the data set is no longer the same.
Please I am new to Power BI and I am learning still at a beginner level. I tried to explain in the best possible way. If anyone can help it would be very kind of you.
Hi,
Share data in a format that can be pasted in an MS Excel file.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 84 | |
| 48 | |
| 36 | |
| 31 | |
| 29 |