Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
How do I make measure1 work like measure2 using set analysis?
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.
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.