How to use- Dual()

[shabarish0587]

Hi Friends,

        Can any one help me how to create WEEKENDSAT by using YearMonth Fields. My Data Looks like this.

Load * Inline

[

YearMonth, IDs

2018-12, 123

2018-12, 123

2018-12, 125

2019-01, 456

2019-01,789

2019-01, 281

];

My Data is look like this. If i select any yearmonth data it should display count of ids by weekend.

[Gysbert_Wassenaar]

Can you explain what WEEKENDSAT is?

And what has the Dual() function to do with it?

[shabarish0587]

Hi Gysbert,
Weekendsat means Week End Saturday. I want to show the data by week, that week starts from Sunday and End with Saturday. I need to create like this
Weekend((Date) 0,6) as Weekendsat.
But here my case is I want to create same thing by using YearMonth Column not Date.

[Gysbert_Wassenaar]

Perhaps like this: Date(WeekEnd(Date#(YearMonth,'YYYY-MM')),'YYYY-MM-DD')