Hello all I need to create a measure that calculates the working hours between 2 dates on a dim table. 3 tables : Tab Dates, Tab TimeSheet and Tab Business Leader. The first 2 are connected through dates but with inactive connection because i have 2 other fact table. This is the desired visual (a…

Hello @Melissa and @AntrikshSharma Thank you so much for all your help and all your attempts on doing so. The formula works like this: T Hr Due = SUMX( VALUES( 'Tab Employee'[id_user] ), CALCULATE( CALCULATE( [DueWorkTime], …

Weekdays between 2 dates on dim employee

DAX DAX Calculations

Melissa February 1, 2021, 12:14pm 2

Hi @pedroccamara,

Think you’ll find all you need here, in the video by @BrianJ

2 Likes