I want to have two Virtual Columns to get the summed cost of
Spring + Summer
and
Fall + Winter
How can I express this?
Solved! Go to 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"
I think in this case should be
[Year]=[_THISROW]
Since Season Table[Year] is a key
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"
I think in this case should be
[Year]=[_THISROW]
Since Season Table[Year] is a key
Thank you very much! 🙂
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |