Hi Team, Looking for a little guidance. I'd like to calculate MTD revenue using week numbers that are tied to a month So for example: Month 1 = week 1/2/3/4 Month 2 = week 5/6/7/8/9 - If i select week 3, i'd like the MTD revenue from week 1/2/3- If i select week 8, i'd like the MTD revenue from week 5/6/7/8 I have a table that associates every week to a given month. Would you happen to know what functions/resources i could use to help me achieve this? Thanks in advance! Ray

basketballer202 , if week and month are part of date table , you can get it using time intelligence MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date])) MTD = var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())var _min = eomonth(_max,-1)+1 ,returnCALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

MTD function based of week num | Microsoft Fabric Community

Forum Discussion

Related content

Change visual sorting based on weeks

Next Week Function

DATESYTD function

Average and Percentage base from number of Week

Week over week measure