Sumifs in power bi
Hey, I have I believe a pretty simple request, I unfortunately cannot seem to figure it out. For the below table created from my dataset set I want to count for each unique order nr determine how many items were purchased total. However everytime I do a formula where Line qty is greater than 1 it returns orders which have a line qty of the value of 2 rather than the sum. Example: order 10000 has 3 unique items with a line quantity of 1 for a sum total of 3. while another order has 1 unique item with a line qty of 2 for a sum total of 2. The below formula keep returning the latter condition and not the former. Sum if line quantity = CALCULATE(SUM(FACT_Orders[Line QTY]),DISTINCT(FACT_Orders[Order Nr]))
Last week today - last year drill down to day results
Hei, I hope you can help me. I need to create a measure that brings data per day for Last week - last year. So far I've managed to bring data per week with this measure: LWTD LY := VAR CurrentWeek = MAX(Time[WeekNr]) VAR CurrentYear = MAX (Time[Year]) VAR PriorYear = IF(CurrentWeek =1, CurrentYear-1, CurrentYear) VAR PriorWeek = IF(CurrentWeek=1, CALCULATE( MAX(Time[WeekNr]),ALL(Time), Time[Year]=PriorYear),CurrentWeek-1) RETURN CALCULATE([Sales],ALL(Time), Time[Year]=PriorYear, Time[WeekNr]=PriorWeek) This gives me the following results where the totals of the week sums are correct. However what I need is to bring data per date, not only the total of the week. How can I achieve this?
