QTD

[cristianml]

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.

I tried to use above Variables but they did not work. Any ideas ?

[Ashish_Mathur · Accepted solution]

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.

[cristianml]

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.

[Ashish_Mathur]

Glad to see that you have solved your own question.