Forum Discussion

Burubear's avatar
Burubear
Helper I
6 years ago
Solved

Calculate the previous date for each item

Hi All,   I want to create a Card graph wherein the Score for this specific team for a specific Quarter Shows Splicers would be Year and Quarter. Then Card shows Score of each team (team A and B) ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Burubear ,

     

    Please create calculate columns as below.

    YEAR pre = YEAR(EDATE('Table'[Date],-3))
    Q pre = "Q" & QUARTER(EDATE('Table'[Date],-3))

    Pbix as attached.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Burubear ,

 

Please create calculate columns as below.

YEAR pre = YEAR(EDATE('Table'[Date],-3))
Q pre = "Q" & QUARTER(EDATE('Table'[Date],-3))

Pbix as attached.