datefunctions
1 TopicPower BI time functions
Hi, I want to create a function in power bi to creates a new colum and adds a certain amount of time depending on a key word that is a period of time in a different column. example: row 1 includes a date in column A and word in column B ( a word like ATO is 6 months) so when row 1 column B is ATO it adds 6 months onto row 1 column A and the new date is placed in new row 1 column C. basically the amount of time added onto the row in column A is dependent on word in the corresponding row of column BSolved1.4KViews0likes7Comments