Forum Discussion
Show
HiTeam,
I am having the data with the columns like Date and amount .
We are plotted column chart with two values (Current year amt and Previous amt).
Requirement:
1. Current year amount data should show till the today
2. Previous year amount data should display after the today
Sample:
Expected Output:
Let me know if you need any details
Thanks,
Siddanth
Anonymous , Example with date table
Year behind amount= CALCULATE(SUM(Sales[Amount]),dateadd('Date'[Date],-1,Year))
Amount =SUM(Sales[Amount]) //this year amount
measure =
if(max(Date[Date]) <=today(), [Amount], [Year behind amount])
2 Replies
Anonymous , Example with date table
Year behind amount= CALCULATE(SUM(Sales[Amount]),dateadd('Date'[Date],-1,Year))
Amount =SUM(Sales[Amount]) //this year amount
measure =
if(max(Date[Date]) <=today(), [Amount], [Year behind amount])
Hi Anonymous ,
Could you please provide some sample data (exclude sensitive data) and the formula of [PY_Amount] and [CY_Amount] if they are measure or calculated column in order to find the problem cause and provide a suitable solution? Thank you.
In addition, please review the following threads and check whether they can help you resolve the problem.
Comparing this year and last year measure on a bar chart
How to compare Last year and Current Year sales in Power BI?
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.