Forum Discussion
Function To Calculate Fiscal Week
Hi all, I want to calculate the number of weeks based on the date of sale, I used the formula: week = WEEKNUM(Scorecard[SalesDate],2) This works very well but not for what I need, Due to work ...
HI JulianTobon
Should be easy enough to fix.
Do you have a Date/Calendar table where you have 1 row per day? I notice your sample data seems to skip lots of days.
Phil_Seamark My data skip dates, because not every day we receive purchases. Example Date/Calendar table:
In Power BI