Help with Embedded Function - Set Analysis

[chris1987]

Hi,

I'm trying to use a function in set analysis without any luck.

The function I'm trying to use is :

=only({<CreatedDate={'=today()'}>}[WeekPeriod])

which returns 201812 (as we're currently in week12 or year 2018)

I'm trying to embed it in this function:

=sum({<[I_Txn-type]={'INV'},[WeekPeriod]={"=only({<CreatedDate={'=today()'}>}[WeekPeriod])"}>}[IL_Net-ext])

but I don't get correct results.

I've tried using single quotes and double quote - the [WeekPeriod]={"=only({<CreatedDate={'=today()'} is just getting ignored all together.

Thanks

Chris

[sunny_talwar]

Awesome

[chris1987]

Thanks Peter, that's really useful!