Forum Discussion
Helper IICumulative result for previous Fiscal Year
Hi Link, thanks for you answer.
Since my last message, I tried several ways and at the end I think I found a solution using two different date tables. The problems were different, but the main were that:1. the slicer was forcing the report to fileter only one year, while I needed more flexibility;
2. the particular definition of a "Year" assumed that the cost elements were related in some cases to more than 12 months and in some other cases, to less than 12 months, and in this scenario also the visualisation with time-intelligent formulas was too strict.
For this reason I used a data date table for the current year (that selected bty the slicer) and another date table for the previous year, using a new calculated column to bring one year forward the data registered for the previous year. I know that maybe this is not the best solution, (I am using powerBI for less than one month!) but it works 🙂
G
Community SupportHi gunicotra,
Could you provide pbix file after removing sensitive information?
With the screenshots I am not sure what is causing this issue.
Best Regards,
Link
Helper IIHi Link, thanks for you answer.
Since my last message, I tried several ways and at the end I think I found a solution using two different date tables. The problems were different, but the main were that:
1. the slicer was forcing the report to fileter only one year, while I needed more flexibility;
2. the particular definition of a "Year" assumed that the cost elements were related in some cases to more than 12 months and in some other cases, to less than 12 months, and in this scenario also the visualisation with time-intelligent formulas was too strict.
For this reason I used a data date table for the current year (that selected bty the slicer) and another date table for the previous year, using a new calculated column to bring one year forward the data registered for the previous year. I know that maybe this is not the best solution, (I am using powerBI for less than one month!) but it works 🙂
G