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 defau...
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.
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.