Forum Discussion
Solved
QTD
Hi, I have an issue trying to calculate a column. I need "QTD" text in QTD column. The Logic is to allocate "QTD" in the current Fiscal quarter that in this case is Q2 for those 3 months. ...
Hi,
Typically, QTD is a measure (not a calculated column formula). Please describe your question and show the expected result. Share the link from where i can download your PBI file.
Hi Ashish_Mathur ,
I solvd by creating a column in "Actuals" table :
Current Q = CALCULATE(MAX(Actuals[Quarter]),'Actuals'[YTD]="YTD")
Then the following column in Calendar table:
QTD =
VAR _1 = MAX('Actuals'[Date])>='Calendar'[Date]
VAR _2 = MAX(Actuals[Fiscal Year])='Calendar'[Fiscal Year]
VAR _3 = MAX(Actuals[Current Q])
RETURN
IF(AND(_1=TRUE(),_2=TRUE()) && _3='Calendar'[Quarter],"QTD",BLANK())
Regards.
Glad to see that you have solved your own question.