Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
bonjour tout le monde,
J'ai fais une formule qui dois tester mes valeurs dans certaines colonnes pour savoir si elles sont vide ou non.
Si une valeur est vide dans une colonne, alors je vais tester pour recuperer la valeur et si dans cette colonne il n'y a pas de valeur, je vais tester dans une dernière colonne.
Mais ma fomule me renvoie aucun résultat :
Voici ma formule :
Hi @Anonymous ,
Is this the exact formula as it will not work based on how it's written. Are value columns in your table straight from the data source or calculated measures?
Did I help you today? Please accept my solution and hit the Kudos button.
it's the exact formula and the value are straight from the data source
@Anonymous , I you checking for blank or 0, see if this can help
Switch ( True() ,
isblank(sum('KPI 06 - Cost Control extractio'[MTN FEES RPT]) ) || sum('KPI 06 - Cost Control extractio'[MTN FEES RPT]) = 0 ,calculate(sum('KPI 06 - Cost Control extractio'[CTUAMOUNT]),
'KPI 06 - Cost Control extractio'[COD STA] IN { "PI" }) ,
isblank(sum('KPI 06 - Cost Control extractio'[CTUAMOUNT])) || sum('KPI 06 - Cost Control extractio'[CTUAMOUNT]) =0 ,
calculate(SUM('Extract SAP du 01-07 au 31-07-2'[Valeur condition]),'KPI 06 - Cost Control extractio'[COD STA] IN { "PI" })
)
Unfortunately it doesn't work...
The goal of this formula is to check if in a ligne of a column there's a blank value and change this value to an other one from a other column
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |