Forum Discussion
Matrix or Table format
Anonymous , From week in the first table you have create a week start or end date.
Then you have create a date table with week details and join both tables on that
And use date and week number from there. Also you need to create common Dimension Table.
new column in budget
Week to Date = var _st = date(2021,1,1) //or user year column date([year],1,1)
var _week = [week]
Return _st+((_week-1)*7) -WEEKDAY(_st,2)+1
For department - https://youtu.be/Bkf35Roman8
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
My main issue here is how can i create a measure that will calculate all of this with this Column Header?
So all of those will be in one matrix.
Hi Anonymous ,
Based on your description, I'm afraid you could not achieve with creating one measure currently in power bi desktop becasuse [Hierarchy] and [Date] field are not in the same hierarchy definition.
In addition, in martrix visual, only fact columns and calculated columns can be put in the column fields, measures could not be put in it.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
