Forum Discussion
Year to Date Function
Create 2 measures for YTD and LYTD and then calculate the percentage diff:
YTD = CALCULATE(SUM(Table6[Amount]),DATESYTD('Calendar'[Date])) YTD LY = CALCULATE(Table6[YTD],SAMEPERIODLASTYEAR('Calendar'[Date]))Measue = ([YTD] - [YTD LY]) / [YTD LY]It seems that the Change % is a column and not a measure.
You should create a measure.
Also the table that you are showing us contains the raw data table.
What is the actual table that you are planning to use on the report. What fields and measures is it going to have?
Community Champion
Create 2 measures for YTD and LYTD and then calculate the percentage diff:
YTD = CALCULATE(SUM(Table6[Amount]),DATESYTD('Calendar'[Date]))
YTD LY = CALCULATE(Table6[YTD],SAMEPERIODLASTYEAR('Calendar'[Date]))
Measue = ([YTD] - [YTD LY]) / [YTD LY]
Thank you for your reply.
I have created the 2 measures and the column with percentage diff calculation. However, it returns an infinte sign. If it helps here a sample the table.
- themistoklis
Could you send a snapshot of the table on PowerBI where the infinite sign appears?
The table that you sent has only 2018 data. Could you share the PBIX file and mask any confidential data?
This is the table that I am working on right now. Please, if you need the file let me know and I will dm you. Thanks in advance for your time.
