dateadd visit windows
2 TopicsWINDOW and RAND
If I have a table, "Table" with an ID column and three columns, "A", "B" and "C". Will the following produce a table with a new column of random numbers that are evenly distributed within each partition of A, B and C? ADDCOLUMNS( WINDOW(1, ABS, -1, ABS, Table, , , PARTITIONBY(zPreviousMYCases[@A], zPreviousMYCases[@B], zPreviousMYCases[@C])), "@Rand", RAND() )Solved749Views0likes3CommentsDATEADD not giving me the dates
I am needing to create a visit window report to show the expected visit windows for visits based on the procedure date. here is what i have uploaded as an example: I am trying to have the [Visit window Start] column display to show the [Procedure] date plus 5 days. (see formula bar for what i used). So for example, the first procedure date is listed as 01-MAR-2020 so the date that should be calculated is 06-MAR-2020. But nothing shows up. What am I doing incorrectly?Solved1.1KViews0likes3Comments