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 ?
How to set the column name to be dynamic in Incorta.Ex: I want the listing insight to show 2022,2021,2020(Last 3 Years) which should be dyanmic , when its next year it would 2023,2022,2021 is ther a way to set it at Lisitng Insight level, I don't wan...
.svg "Captain"){kind=icon}