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! Request now

Reply
pbi1908
Helper III
Helper III

Break a date column

Hi everyone i have a table  like below which is the weekly Payroll for each department. In the week ending is always Sunday to indicate the the corresponding week. 

 

I want to transform this table so to have one column for the values (Hourly STD, Hourly OT, Fringe) and to break the week ending into weekdays. So my table i want to looks like the 2nd screenshot, so not only break the week ending to weekdays but triplicate wach weekday cause of the types. So for example if i have a week ending 2 times i want to transform it to 2*5(weekdays)*3(types) =30 lines 

and i want to do this in DAX do you have any idea how can i do it ?

 

screenshot 1

 

pbi1908_0-1679837334205.png

 

 

screenshot 2

 

pbi1908_1-1679837358333.png

 

 

 

 

 

 

I attached also the excel file just in case.

 

https://docs.google.com/spreadsheets/d/1tUE6cpEiIlL1hBrZa8zPrEhSjFSusI47/edit?usp=share_link&ouid=11...

1 REPLY 1
CNENFRNL
Community Champion
Community Champion

CNENFRNL_0-1679852958467.png

 

CNENFRNL_0-1679857206375.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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
Top Kudoed Authors