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.
have you tried using format function for date format?
I am an absolute newbie to DAX, could you show me how to use it? Thank you.