Forum Discussion
Solved
Single Yearly File and Months Comparison Chart
Hi everybody, I have an excel file made of X rows and 2 columns. The rows are the dates (more or less all the days in a year) and the columns are the $ income and notes. Is there a way to have a si...
Hi Tigex,
I attached the file here: https://1drv.ms/u/s!ArTqPk2pu-BkgQzkLSKO_LWuXijo, which would be a clear explanation.
1. One date table (Calendar) and your data table (table1);
2. 12 measures. (copy and paste, then change 1 to 2 - 12).
January = CALCULATE ( SUM ( Table1[Value] ), FILTER ( 'Calendar', MONTH ( 'Calendar'[Date] ) = 1 ) )3. Create a visual.
Best Regards!
Dale
Hi Tigex,
I attached the file here: https://1drv.ms/u/s!ArTqPk2pu-BkgQzkLSKO_LWuXijo, which would be a clear explanation.
1. One date table (Calendar) and your data table (table1);
2. 12 measures. (copy and paste, then change 1 to 2 - 12).
January =
CALCULATE (
SUM ( Table1[Value] ),
FILTER ( 'Calendar', MONTH ( 'Calendar'[Date] ) = 1 )
)3. Create a visual.
Best Regards!
Dale
Thank you very much ... without your help i would never have done it ... !
I really appreciated, you made my day.
Fabio