Filters

PhilippeMuniesa — Sun, 21 Feb 2021 17:16:09 GMT
Hello,

I start with PowerBi and dax

I built a PowerPivot Excel 2019 project.

This project is based on the accounting entries of several years, all the entry lines of the different years are placed in a "FEC Concatenation" table

The fact base contains an exercise column

The Management_exercise table contains the list of managed exercises

depending on the case, there may be 1, 2 or 3 exercises managed

ex: 2019 only
ex: 2019, and 2018
ex: 2019, 2018 and 2017

I build comparative reports

with, in columns the exercises online 

accounts in value the balances 
>> Amount_signé_m: = SUM ('Concatenation_FEC' [Credit]) - SUM ('Concatenation_FEC' [Debit]) 

and the variation in value between fiscal years 
>> Var N-1 Mt_sign_FEC: = [Amount_signé_m] - CALCULATE ([Amount_signé_m]; SAMEPERIODLASTYEAR (Gestion_exercise [Date_cloture])) 
However, when there are only two fiscal years 2019 and 2018, the 2018 and N-1 variation is equal to the 2018 balance. What I would like is that when N-1 is not present, or when it is the first exercise; the variation column is not displayed. 

Project and assiociated files download link

https://www.dropbox.com/sh/2afnfc8jz09m29d/AABUwgS9cm52UOSbiUo9mZH3a?dl=0
I don't know how to do this, and any help would be greatly appreciated.

Thanks a lot 

Philippe Muniesa
topic Filters in DAX Commands and Tips

Filters
