Date dimension/formula problem

Jones01 · 2022-09-28T19:26:22+00:00

There was an error rendering this rich post.

Hi,

I'm not sure what I am trying is possible but here goes.

I have my data stacked as per @GrantSmith's excellent post.

What I need is a calculated column for the last year column that only includes the value if "Another Value" from the This year row = 'Y'

So only show 600 if another value =Y from period type this year

So I have

sum(case when `Period Type` = 'Last year' then `value` end)

Can this be extended to do what I need?

I have tried a few things such as below

case when sum(case when `Period Type` = 'This year' AND `Another Value` = 'Y' then 1 end) = 1 then sum(case when `Period Type` = 'Last year' then `value` end) end

but this won't work...

Any help would be appreciated.

Thanks

Find more posts tagged with

Beast Mode

Accepted answers

All comments

Jones01

@Mod can this be moved to dataflows please

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of