Forum Discussion
yve214
Helper III
Helper IIIHow to get fixed values without aggregating
Assuming I modeled my fact table to my date table through the date and fact_table date column, how can I calculate say the qty for just that specific date (week end date Sunday only) without aggregat...
yve214 , You can create a flag for that and use that in filter
new column
Weekend = if(Weekday([Date],2) =7,1,0)
new measure =
calculate(sum(Table[Qty]), filter(Table, Table[Weekend ] =1))
or , without new column
calculate(sum(Table[Qty]), filter(Table, Weekday([Date],2) =7))
yve214Helper III
Helper IIIamitchandak Oh my, it was such a long day. and I dont know how I didnt think of an option like this, such a lightbulb, thank you very much.