Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
107 | |
68 | |
48 | |
47 | |
44 |