topic Min Date with Or Condition in Dashboards & Analytics Discussions

Min Date with Or Condition

KHK — Wed, 28 Jun 2023 05:54:35 GMT

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(table[OPEX_PRICE]))

anurag — Wed, 28 Jun 2023 14:13:32 GMT

OR will work at the row level and you have aggregation inside OR function.

One option you have is:

You can aggregate your data using resultset and then apply OR function to the output of the resultset.