Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
ahmedtofayel
Regular Visitor

How to Handle Multiple Date Columns

Hello everyone,
I have a dataset where there are two date columns and I would like to achieve the following from these columns:
data.pngworkflow.png
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.

 

 

1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

Share data in a format that can be pasted in an MS Excel file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors