DAX command to sum value column when there is only value in other column
I have two columns in my table. CYW - Current Year Weekly value and PYW - Previous Year Weekly value. I want a dax command to sum up CYW when there is only value in respective week in PYW. Eg: Year 1 has sales starting from 14th week. Year 2 has all 53 weeks. Now I want to sum up values in year 2 only from 14th week. Kindly suggest a DAX command for this. something like, If pyw sale is blank then blank else sum cyw Pbix file
Help Needed! Week over Week revenue calculation "group by" categorical data
I am trying to figure out week over week calculation. I searched online and found DAX measure. I created columns for Year, WeekDay, and WeekNum. what I am using is like below: WoW Rev OTB = SUM ( 'Table'[sales] ) - CALCULATE ( SUM ( 'Table'[sales] ), FILTER ( ALL ( 'table' ), 'table'[Year] = MAX ( 'table'[Year] ) && 'table'[WeekNumber] = MAX ('table'[WeekNumber]) - 1 && 'table'[WeekDay] = MAX ( 'table'[WeekDay] ) ) ) The result turned very well, I got the total number for week over week revenue by different as of dates. It looks like the picture below: However, when I clicked slicers with categorical data, trying to see week over week revenue by filters, all the numbers showed negative: Eventually I wanted to present week over week in a column chart by As of Date. I have tried multiple measures from Power BI Community, but all the measures couldn't work when values apply on categorical data. I'm wondering if the measure should calculate by row, but mine is by column. Does anyone be able to help me with the week over week formula? Thank you in advance! Here is the pbix file without sensitive data: test-laughing chicken.pbix
