Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , 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!! 🙂
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |