cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Aaron1 Frequent Visitor
Frequent Visitor

Calculate YTD , QTD & PTD in a column so it can be used as an axis or legend

HI, hopeful for some help!

 

We would like to create a view of YTD, QTD & PTD that can be used either in the axis or legend of a visual. Our data is aggregated by week, depending on the week, it could appear in upto 3 places i.e. the latest week would be in YTD, QTD and PTD. 

 

We have a work around at present that relies on aggregating the data in alteryx and uploading it as a seperate (large) data table. We would like to be able to do this from the core data so it is dynamic rather than creating another huge data set.

 

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Calculate YTD , QTD & PTD in a column so it can be used as an axis or legend

@Aaron1,

 

Learn DAX basics in Power BI Desktop and show us a complete example.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 233 members 2,886 guests
Please welcome our newest community members: