Forum Discussion

JulianTobon's avatar
JulianTobon
Helper I
9 years ago

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 ...
Need Help
JulianTobon's avatar
JulianTobon
Helper I
9 years ago

HI Vvelarde 

 

This formula Did not give correct data

 

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

JulianTobon

 

Ok, maybe your structure is different in my scenario. 

 

Hi,