Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Anonymous
Not applicable

DAX in Power Bi YTD calculations and month values

โ€Ž03-01-2021 04:19 AM

I need help with the calculations with the YTD calculations, and Month values.

My table is called TBL_Indicator and the structure is the following

 

 

My issue with the YTD is that it need to be filter by a column named Filter (mmm/YYYY - Jan/2020), and my month values should be the Divide(sum[value],Sum[Total]) based also on the filter column.

 

I have created also a Calendar table using the following structure.

DATES = CALENDAR(DATE(2020,01,01),DATE(2021,12,01))
YEAR = YEAR(DATES[Date])
MonthNumber = MONTH (DATES[Date])
MonthPrefix = FORMAT (DATES[Date],"mmm")
Filter = CONCATENATE(DATES[MonthPrefix],CONCATENATE("/",DATES[YEAR]))
 
I want on the matrix to be able to filter by Country and Filter, without the data being all summarized and giving values like 1500%
 
Thank you in advance for your help ๐Ÿ™‚
 

 

1,042 Views