Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
4 years ago
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.   ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

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's avatar
    cristianml
    Post Prodigy
    4 years ago

    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's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Glad to see that you have solved your own question.