add YTD in consecutive months

[NILU090]

Hi team,

I have following model in data.
i need output in metrix with custome column added ( YTD till OCT as current month is OCT)

and QTD column in every quarter.

please help me on this

[Ashish_Mathur]

Hi,

Why are there no other quarter total columns?  Also, how can there be data for November and December.  Share the link from where i can download the PBI file.

[NILU090]

Hi Ashish,
i gave example of quarter column. we need 1 column for every quarter. so there will be total 4 columns for year.
Regarding Nov & Dec, this is confirmed amount that we will receive in these month. There are some values already confimed for next year too. This is perticular scenario we have.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[amitchandak]

@NILU090 , In case these is not filter on page , You a measure like this

YTD Today =
var _min = eomonth(today(),-1*month(today()))+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Have Qtr year and Month Year from Your date table on column and expand and use .

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...

[NILU090]

Yes we can use qtr-yr column but how we can insert it in to month as presented in screenshot?