Ratio by product

[Chedva]

Hi,

I want to creat a few measures of ratio's for the different products within a product platform, (See highlighted columns, thatt's the measures I need. 

Product Platfrom	Product	Last 6 month ratio	Last QTD ratio	QTD ratio
A	A+
A	A-
B	B	100%	100%	100%
C	C+
C	C-
C	CC

I have the product actuals by date, related to a date table, and by product and by product platform.

How can I do this?

[amitchandak]

@Chedva ,

Try time intelligence with date calendar like

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
Last complete QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD( ENDOFQUARTER(dateadd('Date'[Date],-1,QUARTER))))

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-6,MONTH)) 
Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-6,MONTH))  
Rolling 6 before 6= CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(dateadd(Sales[Sales Date],-6,month)),-6,MONTH))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[Chedva]

@amitchandak Hi,

Looks to me like the measure will give me the actuals, which is a good start,

How does these solution take into account the calculation of ratio of product within the product platform.

What % is the C-/C & the C+/C in the last 6 month?

Thanks!

[amitchandak]

@Chedva , Refer this should help

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390