Have MTD/QTD/YTD in rows

[Anonymous]

	Net Sales $	Units #	Orders #
MTD
QTD
YTD

I would like to have a table where the rows are different date demensions. I am using a retail calendar (so different months and years then a calendar). The calendar table already has a yes or no for each deminsion if it is in it (ie 2/10/2019 is Yes for month, Yes for Quarter, and Yes for Year)(1/20/2019 would have No for month, Yes for quarter, and yes for year). Is there a way to make a row for each date deminsion and just return values for YES?

[v-yuta-msft]

@Anonymous ,

You can create three calculate column MTD, QTD and YTD then drag the three calculate columns into a matrix visual as row field.

Community Support Team _ Jimmy Tao

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

[Anonymous]

Any other help on how to do that? 

[Anonymous]

Calculated coloumns to of the dates in MTD/QTD/YTD?