Forum Discussion
MiguelSaldana77
Resolver I
Resolver ITable with different periods on columns
Hi everyone, It´s possible to present the same measure but with different period? The image shows the sales of the month of November (synchronized with the monthly filter) and in the same table s...
Hi, I finally made the annual measure
Anual Sales = CALCULATE(Sum(H_Viv[Sales]),FILTER(All(Std_Time),Year(Std_Time[Date])= Year(Std_Time[Date])))
MiguelSaldana77Resolver I
Resolver IThanks @AIB well, the structure is very simple, I have a Fact Table and differents Catalogs for the differents dimensions and I have a Catalogo for the Time.
So, If I use a week filter, I have to do an calculated measure ussing that formula ?
Vvelarde
Community Champion
Community Champion
Hi, create a Basic Measure like SUM(Sales).
And after that create measures with the desired period. Monthly, Anually, etc
Regards
Victor
- MiguelSaldana77
Thanks for your help to everyone
I was working with the formulas and I got this for the Monthly Measure, but I couldn´t made work the anual measure.
Could anyone help with the annual measure, please.
Monthly Sales = CALCULATE(H_Viv[Sum Sales],FILTER(All(Std_Time),MONTH(Std_Time[Date])= MONTH(MAX(Std_Time[Date]))))The annual doesn´t workAnnual Sales = CALCULATE(H_Viv[Sum Sales],FILTER(All(Std_Time),Year(Std_Time[Date])= Year(MAX(Std_Time[Date]))))- MiguelSaldana77
Hi, I finally made the annual measure
Anual Sales = CALCULATE(Sum(H_Viv[Sales]),FILTER(All(Std_Time),Year(Std_Time[Date])= Year(Std_Time[Date])))