SELECT expression help

[NCD]

I want to have two Virtual Columns to get the summed cost of

Spring + Summer 

and

Fall + Winter

How can I express this?

[Suvrutt_Gurjar · Accepted solution]

Select() expressions in VCs tend to be sync time expensive especially if you have large number of records . Please explore using security filters etc. if that is the case.

You can get the necessary values by using the expressions something like

SUM(

         SELECT(Season Table[Cost],

                     AND( [Year]=[THISROW].[Year],

                    OR([Season]="Spring" , [Season]="Summer")

                            )

                        )

                )

Similarly for "Fall" and "Winter"

[Suvrutt_Gurjar · Accepted solution]

Select() expressions in VCs tend to be sync time expensive especially if you have large number of records . Please explore using security filters etc. if that is the case.

You can get the necessary values by using the expressions something like

SUM(

         SELECT(Season Table[Cost],

                     AND( [Year]=[THISROW].[Year],

                    OR([Season]="Spring" , [Season]="Summer")

                            )

                        )

                )

Similarly for "Fall" and "Winter"

[SkrOYC · Accepted solution]

I think in this case should be

[Year]=[_THISROW]

 Since Season Table[Year] is a key

[NCD]

@Suvrutt_Gurjar @SkrOYC 

Thank you very much! 🙂