Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Create calendar table or filter table

Hello I hope you are very good, I have this problem for a while and I do not know how to start, I have these 3 tables which I need to do some operations to give me some indicators, from the T9 t...
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
3 years ago

Hi Syndicate_Admin ,

 

If after relating it I can operate formulas in dax of t13 and t9 and the current filters would take them?

Yes, please create relationship between them and set the filter direction to both.

 

How can I convert the period that is in whole number to month and date format?

Whole number to month and date format please use dax DATE(<year>, <month>, <day>)

DATE function (DAX) - DAX | Microsoft Learn

 

Can the array visual I'm using to see filters and filtered data place that data in rows and not columns?

Not quite sure what you mean, just swap the row and column fields of it.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.