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

Forum Posts

Dynamic date range

Hi, i want to run my report for every year previous year October 1st to current year October 31st.I.e 01/10/22 to 31/10/23.could you please let me know how to write formula

KHK by Partner
  • 1274 Views
  • 7 replies
  • 0 kudos

Resolved! SUM on MAX values

Hi,I am migrating Power bI reports to Incorta.In Power Bi report, they are fetching max value of one column and doing sum on that.IN Incorta, i have created formula column in business view with max function and called this in measure column in Aggreg...

KHK by Partner
  • 1298 Views
  • 3 replies
  • 0 kudos

Min Date with Or Condition

Hi Team,Could you please let me know how to convert below formula in Business view. I want to use te result of data in another formula.OR((MIN(table.[FISCAL_YEAR])) >= 2022, NOT(ISBLANK(SUM(table.[ORDER_INTAKE])))), SUM(table.[ORDER_INTAKE]), SUM(tab...

KHK by Partner
  • 496 Views
  • 1 replies
  • 0 kudos

Resolved! Measure in KPI

Hi,I have created below measure formula in business view using string to count the number of rows of string.Requirement: count(table.name = "Yes").Written formula in Business View:if(    table.name = "Yes",     count(        table.name    ),     0)Ca...

KHK_0-1687804441577.png KHK_1-1687804696324.png
KHK by Partner
  • 709 Views
  • 3 replies
  • 0 kudos