topic Re: If condition in App Development

If condition

dhruvipanchal88 — Tue, 22 Feb 2022 16:52:17 GMT

Hi,

In visualization, I wanted to show only Q1 data in table 1 and similar way Q2 data in table 2 in one sheet.

Can anyone suggest formula?

Dhruvi

MarcoWedel — Tue, 22 Feb 2022 17:51:55 GMT

Iswarya_ — Tue, 22 Feb 2022 18:10:53 GMT

You can use set analysis in the measure and filter the data needed

table 1 for Q1: Jan-Mar

Sum({<Date={">=$(=QuarterStart(YearStart(Today(),0,1))) <=$(=QuarterEnd(YearStart(Today(),0,3)))"}>}[Nett Amount new EUR])

table 2 for Q2: Apr-June

Sum({<Date={">=$(=QuarterStart(YearStart(Today(),0,4))) <=$(=QuarterEnd(YearStart(Today(),0,6)))"}>}[Nett Amount new EUR])

dhruvipanchal88 — Thu, 24 Feb 2022 14:39:34 GMT

It worked. Thank You

Iswarya_ — Thu, 24 Feb 2022 15:07:52 GMT

If the issue is solved please mark the answer with Accept as Solution.

MarcoWedel — Thu, 24 Feb 2022 19:23:55 GMT

glad it worked.

please close your thread by accepting a solution.

thanks