如何在添加【数据模型】的数透表中，按照步长组合日期数据？

[IreneXu]

在我使用数透模型时（注意是模型，而非简单的数透表），我希望使用“非重复计数功能”，同时组合以周为单位日期，似乎不可以组合。如有解决方案，请随时联系我。by the way 在简单的数透表下，可以按照7天组合，但是这样我就失去了非重复计数功能。

Thanks

[#2]

If possible,please provide some datas and expected result.
If it is impossible to achieve the goal by
pivot table directly,I guess we need apply ETL or data clean by SQL or Power Query.

[#3]

请查看该链接：Test-excel.xlsx

我还不会用ETL & SQL，您有什么建议吗？

如有任何需补充事项，欢迎随时联系我。

---

@peiyezhu wrote:
If possible,please provide some datas and expected result.
If it is impossible to achieve the goal by
pivot table directly,I guess we need apply ETL or data clean by SQL or Power Query.

---

[#4]

@IreneXu 

Thanks for your feedback.

I can see the Sheet1 as source data and can not find the expected result according to the Sheet1.

I guess you want the distinct count of each group.

online sql:

 create temp table aa as 

select *,rowid/7 week from Sheet1;

select week,数字,count(distinct(数字)) from aa group by week,数字;

 

If with pivottable,you can add a help column before get the count.

c2:

=INT(ROW()/7)