qtd

Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD. So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year. This is my MTD formula: =if(month(dCalendar[dateS])=month(today()) &&...

I've tried every formula I could find online and in Excel help. I have a spreadsheet with many columns. Column B contains business tracks; QTD, ATM, PLM, etc. Column I contains the dates new items where added to the spreadsheet for each business track. Their may be as many items listed for QTD...

Hi Everyone, I need some help in calculating QTD for mutilple years, months and dates, please see the table below. My actual sheet will have data from 2018 to future years by each month. And each month could have multiple dates in it, like shown in the sample data. I would like to display the...

Hello everyone, I have a QTD measure that is almost working, It calculates the current QTD value exactly as I would see it in our ERP, but I would like it to respond to the month selection, based on a <= calculation. My current measure is, =CALCULATE(SUM('Income...

Hello. I am trying to see if it's possible to create a formula that can do a QTD (quarter to date) or YTD (dynamic range) formula with index, match, match. I have index match match which gives me a single month's data, and I have a QTD index match formula, which can give me the qtd data through...

Does anyone know what the R means when used like this: R4Q We all know there about 2017 YTD (Year To Date) or Q4 QTD (Quarter To Date) no idea what the R would be for. Anyone? Thanks Julie