Week commencing as a row not working

[Anonymous]

Hi guys, looking for help with the week commencing field in Power BI.

I added a column in Power Query using the 'Week commencing ' option, which has worked fine when i use it just for a scorecard or similar to return therdate for Monday of each week.

however, when I try to do something else with it, like create a matrix with the week commencing as a row, it won't pull into the field. 

Any ideas what's happening? I wanted to avoid making a data table if I could!!

Thanks,

Gem

[amitchandak · Accepted solution]

@Anonymous , You should be able to use a column created in the power query in a matrix row or column.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

dax column

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

[Anonymous]

Hi, there's no sensitive data (I'm using dummy data to make the report, and it's aggregated already by email campaign), but no idea how to export as you say above!! 🙂