Forum Discussion
Week commencing as a row not working
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
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
2 Replies
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