My first week of 2022 data is Jan 2, and I would want the week number to output 1. The ultimate goal is when I select a date, it will output the same number of weeks for the prior ytd. For example, if I select May 28, 2023, that is the 22nd week in 2023. So, I want to...
They both start in January but the difference is that in fiscal period the user follows the 4-4-5 plan for the week, therefore the fiscal months are not same as calendar months. Eg: For the year 2024 Fiscal months start as follows Jan: 1st Jan to 27th Jan (4 weeks) Feb: 28th Jan...
_PYTD = CALCULATE([KPI %OVR],DATESYTD(cCalendar[Date])) --> YTD Now what I want is to basically for each employee for which I am calculating these 2 measureas, to have a formula that counts how many months in a year, the employee excedeed the KPI target. Basically I would like ...