Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
screenshot 2
I attached also the excel file just in case.
| 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! |
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!