Hi everyone,I'm looking to write a formula such that the startdate of the year (Jan 1st) is obtained based on the year of the previous month.For example :if the input is "2022-01-01" then the formula should return "2021-01-01" (Since year of previous...
Hi Team,I want to retrieve min date from two tables and max date from two tables. Below is the formula. Please let me know how to achieve in Incorta.ADDCOLUMNS( CALENDAR( MIN( MIN( Table1. Date), MIN(Table2.Date) ), MAX( MAX( Table1....
Hi Team,I have one requirement.In my dashboard i have date prompt filter, that filer is current date of transaction date to next 3 years of transaction date, i.e 6/7/23 -6/6/26.could you let me know how to achieve this dynamically.This date range cha...
Hi there,Im using weeknum function but it seems that results at not correct eg below. Column manual shows proper CW from the week numbers table 2021. First row 5 november 2021 - CW44 but according to function CW45 ... why ?Next question why when ther...
Hi,I need to calculate the difference amongst values present in three columns.It needs to look something like this:ABCDifference1010100101091100010109101Can someone guide me to formula or function that can help me acheive this result ?
