Set Analysis Date Match (Tricky Question)

vkish16161 — Tue, 21 Apr 2020 15:29:29 GMT

All,

How do I make measure1 work like measure2 using set analysis?

Re: Set Analysis Date Match (Tricky Question)

agigliotti — Tue, 21 Apr 2020 15:53:03 GMT

maybe this:

load *,
recno() as recordNumber;
LOAD * INLINE [
Date1, Date2, Sale
1/1/2020, 1/1/2020, 100
1/1/2020, 1/2/2020, 200
];

=sum( {< recordNumber = {"=Date1 = Date2"} >} Sale )

I added the field "recordNumber" because you need a primay key.

I hope it can helps.