Forum Discussion
Solved
date in table using date/time variable from another table
The company I work for has data sets for us to work with, and in one of those data sets is a certain date/time variable. Let's call it DATEX. I want to use this variable in another table, but on...
Hi rsch91 ,
Based on the description, creating a calculated column.
FormattedDATEX = FORMAT('Table'[DATEX], "yyyy-mm-dd")Then, creating a new table.
NewTable = SUMMARIZE( 'Table', 'Table'[FormattedDATEX] )Besides, creating a new calculated column.
NewCalculatedColumn = IF( NETWORKDAYS(MIN('Table'[DATEX]), NewTable[FormattedDATEX], 1, {DATE(2024,11, 6)}) < 0, BLANK(), NETWORKDAYS(MIN('Table'[DATEX]), NewTable[FormattedDATEX], 1, {DATE(2024,11,6)}) )Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rsch91
you can refer the new column in your dax instead of old datecolumn, it will be similar to your datetime column just that it wont have time part, only dates.
The thing is, it won't let me refer to the new column in the IF-formula.
why?