Forum Discussion

STS_Joshua's avatar
STS_Joshua
Helper II
6 years ago
Solved

Help with a calculated column

Hi All, I want to calculate a column. Every week I receieve sales data on saturday but I would like to normalize these dates. I want to calculate a column that will take the weeknumber of all input...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi STS_Joshua , 

    I am not sure whether this is what you want, you could try below calculated column to see whether it work or not

    Column = var minday=MINX(ALLEXCEPT('Table (2)','Table (2)'[Week]), DAY('Table (2)'[Period Date]))  return  date('Table (2)'[Year],MONTH('Table (2)'[Period Date]), minday)

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.