2021-12-04

Computing starting and ending date labels for each week in a month in PowerBI PowerQuery

enter image description hereI have data regarding dates in a fact table in PowerBI. See the attached sample, DateFactTable, for 10/2021 (October 2021). A week starts on a Sunday. Note that 10/2021 has 6 weeks and weeks 1 and 6 are split across two months; week 1 has only 2 days and week 6 haenter image description heres only 1 day in October. I would like to compute labels in PowerQuery for each day of the month and put them in a separate column for this fact table. See the attached "Expected Output" pdf for the expected output; note the outlined column called "Week Label" that I would like to add. Any help appreciated. Thanks



from Recent Questions - Stack Overflow https://ift.tt/3onjbXa
https://ift.tt/3EqsxXI

No comments:

Post a Comment