Forum Discussion
Question about data refresh
Have you looked into PU HT and Quantite Facturee to ensure that they are filled in and are numeric fields so that your calculated column will perform as necessary? Also, do you NEED it to be a calculated column (i.e. are you using it to filter data later)? A measure may be better here. If the need is there for this to be a column it is best to add them as far upstream as possible (if you can't add it to your source, add in Power Query, if you can't add there then add as a calculated column).
Hi !
Thanks for your reply, I tried to schedule a refresh and it seems to have an issue when I'm refreshing the data.
I have this message :
" The query has referenced the calculated column '<oii>IX-Facturation</oii>'[<oii>Montant facturé</oii>] which contains no data, as the evaluation of one of the rows has caused an error.
Try again later or contact support. If you contact support, please provide this information. "
I used a formula for "Montant facturé" who is :
Montant facturé = 'IX-Facturation'[PU HT]*'IX-Facturation'[Quantité Facturée]
Super UserHave you looked into PU HT and Quantite Facturee to ensure that they are filled in and are numeric fields so that your calculated column will perform as necessary? Also, do you NEED it to be a calculated column (i.e. are you using it to filter data later)? A measure may be better here. If the need is there for this to be a column it is best to add them as far upstream as possible (if you can't add it to your source, add in Power Query, if you can't add there then add as a calculated column).