Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you explain what WEEKENDSAT is?
And what has the Dual() function to do with it?
Perhaps like this: Date(WeekEnd(Date#(YearMonth,'YYYY-MM')),'YYYY-MM-DD')