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.
hi all,
I have data in the following format.
I want to specify from 2018-Q1 to 2018-Q2, sum all company units and divide by total market units.
Aka. YTD, how can i do this with periods that are in Quarters? I have deselected the time-intelligence in options.
Also, if i have sales data by week or month, how can i do similar YTD calculations without having dates?
Solved! Go to Solution.
i created a new comlumn in the edit query, based on the text date column.
2018-Q1 to 2018-01
2018-Q2 to 2018-04
2018-Q3 to 2018-07
2018-Q4 to 2018-10
and made this new column defined as date, it worked but seems like a suboptimal solution.
Hi @Anonymous
Is the "Period" column a text type column or date type?
I'm afraid if your dataset doesn't contain any date column, it is not posssible to do YTD calculations.
You could create new date columns according to "Period" column, thus you could do YTD calculations.
Best Regards
Maggie
i created a new comlumn in the edit query, based on the text date column.
2018-Q1 to 2018-01
2018-Q2 to 2018-04
2018-Q3 to 2018-07
2018-Q4 to 2018-10
and made this new column defined as date, it worked but seems like a suboptimal solution.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |