Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
Hi,
Share the download link of your PBI file.
@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 .
Yes we can use qtr-yr column but how we can insert it in to month as presented in screenshot?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |