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

Forum Posts

Resolved! Incorrect Month Sorting

Hi there Community,I'm just starting my adventure with Incorta, so first problem appear, thats Why Im asking for help.I have a problem with the proper sorting of months, from what I can see they are sorted alphabetically, and I would like them to be ...

Random_1191_0-1681748219220.png Random_1191_1-1681748324732.png

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
  • 1290 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