previous week
Hi, I would like to create a measure that allowed me to show the previous week value. When the user click wk 32, then the graph will shown the current week (wk32) and previous week (wk31) data in a graph. the graph is clustered column chart and the xaxis will be category, weekday short; yaxis will be previous week (light colour) and current week (dark colour). Previous Week = calculate(sum('Flow '[Value]),FILTER(all('Calendar'),'Calendar'[Date]=MAX('Calendar'[Date])-7)) current week=sum('Flow'[Value]) The issue that i having now is the pic 1 is under category (for the previous week suppose the sum of pic 2 but just obtain sunday value). Can anyone help me to change the previous week dax so that the under category can get the sum from monday to sunday. Thanks for your help. (pic1) (pic2)greater than
Hi, It might be an easy question but I can't figure out the correct method. I have a category list Category Sub A 1 A 2 B 3 B 4 Timestamp Value Sub 5/6/2022 40 1 5/6/2022 100 3 5/6/2022 50 3 I would like to calculate true or false (if 3 value larger than 60 then true, less than 60 then false ; if 1 value larger than 50 then true, less than 50 then false) I'm try using code below. Total value 3= CALCULATE( NOT ISEMPTY(Total value),Total value[Value] >60 ) Thanks for your help.
