Forum Discussion

Gemni's avatar
Gemni
Regular Visitor
1 year ago
Solved

Adjusting Week Grouping Logic in Power BI Matrix Table

hi! im new here, can someone pls help me with this? thank you!   i have a matrix table rows: nr tagging[new region], customer[customer name] columns: productivity[weekperiod] values: product...
  • lbendlin's avatar
    lbendlin
    1 year ago

    All of this is immutable.  There is no need to calculate this with Power Query or DAX.  Use an externally sourced calendar table that for each day indicated which week sub group it belongs to.

     

     

     

lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523