Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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.
Any other help on how to do that?
Calculated coloumns to of the dates in MTD/QTD/YTD?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |