Forum Discussion
Make a variable only show data for the future.
I have a bar chart that is comparing two different things. Lets call it past sales and expected sales.
What I want is for last week and previous, only show past sales (which is how it is by default since sales are 0 in the future), but I wanted expected sales only for the future.
Currently we have past and expected sales in the past, and only expected in the future. I want past sales in the past and expected only in the future. So something like a relative date where it is today and one year in the future.
Any advice?
Anonymous , A measure like
Future = calculate(sum(Table[Sales]), filter(Table, Table[Date] > Today())
Past= calculate(sum(Table[Sales]), filter(Table, Table[Date] <= Today())
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
1 Reply
Anonymous , A measure like
Future = calculate(sum(Table[Sales]), filter(Table, Table[Date] > Today())
Past= calculate(sum(Table[Sales]), filter(Table, Table[Date] <= Today())
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.