Forum Discussion
Solved
Showing icon based on conditional formatting while comparing with the previous day data in a matrix
Hi, I want to visualize the sales data with an indicative icon. The data looks like below I want to visualize the data in the following format in a matrix table I am aware that the ico...
Hi subhendude
Thanks for the reply from amitchandak , please allow me to provide another insight:
Create a calculated column as follow
Column = VAR _earlier = 'Table'[Date] VAR _earliersales = CALCULATE(SUM('Table'[Sales]), FILTER(ALLEXCEPT('Table', 'Table'[Items]), _earlier = [Date] + 1)) RETURN [Sales] - _earliersalesOutput:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi subhendude
Thanks for the reply from amitchandak , please allow me to provide another insight:
Create a calculated column as follow
Column =
VAR _earlier = 'Table'[Date]
VAR _earliersales = CALCULATE(SUM('Table'[Sales]), FILTER(ALLEXCEPT('Table', 'Table'[Items]), _earlier = [Date] + 1))
RETURN
[Sales] - _earliersales
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Absolutely fantastic Anonymous
