Forum Discussion
Helper IVYTD
Hi kalkhudary ,
You can refer the following links to get YTD and the percentage:
YTD:
How to Create YTD Calculations in Power BI
Power BI Tips: Calculate Year-to-date Values
Sales YTD = TOTALYTD ( SUM ( Orders[Sales] ), Orders[Order_Date], ALL ( Orders ) )Percentage:
YTD% = CALCULATE ( SUM ( 'your ytd table'[your ytd column] ) / MAX ( Dates[Date] ) )
If the above ones can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
kalkhudaryHello Ying,
thanks alot for your help but this dax equation did not work in this context. I have attached for your the sample visual and metrics I am looking at as I did not find any option to attach a pbi file. So I am looking to get the % YTD change and last year index as well ( the orange boxes). Numbers are wrong now, I demoed them as example result.
When I click on a particular point on the visual line, I want to see the current price index, last year index, last quarter % change, last year % change and most importantly YTD% change index. I am looking to write a dax syntax that would yield the YTD% change index and the last year index seperately. So when you click on a particular point in the visual, they will all show.
Is this doable?
Hi kalkhudary ,
You can paste your data with Text format in your reply directly. Or you can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards