Set Analysis Date Match (Tricky Question)

[vkish16161]

All,

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

[agigliotti · Accepted solution]

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.