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...
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 , 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
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!! 🙂