Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Retrive MIN and MAX Date

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....

KHK by Partner
  • 724 Views
  • 2 replies
  • 0 kudos

weeknum function bad results

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...

Random_1191_0-1685684132102.png Random_1191_2-1685684293735.png Random_1191_1-1685684269347.png Random_1191_3-1685685111501.png