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.

 

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

 

 

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.

3 Replies

  • 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.