Table with different periods on columns

[MiguelSaldana77]

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 show the annual sales, Is it possible?

Thanks

[v-yuta-msft]

@MiguelSaldana77,

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 show the annual sales, Is it possible?

Thanks

---

Could you share more details about relationship between Actual Month and Actual Year? For example, which kind of DAX formula are you using? In addtion, if possible, could you share the original table, not the cahrt? Mark sure mask the sensitive data.

Regards,

Jimmy Tao

[MiaZhao]

Hi ,

Have you tried to use function YTD() and MTD()?

[AlB]

Hi @MiguelSaldana77

Just using an ALL() on the month column should do the trick. Something like 

SUM(Tables1[Sales], ALL(Table1[Month])

Be careful thought with the year. If you show the structure of your data model we could be more precise with the solution

[MiguelSaldana77]

Thanks @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]

@MiguelSaldana77

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 work 

Annual Sales = CALCULATE(H_Viv[Sum Sales],FILTER(All(Std_Time),Year(Std_Time[Date])= Year(MAX(Std_Time[Date]))))

[MiguelSaldana77 · Accepted solution]

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])))