Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!! 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
65 | |
63 | |
56 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |