Forum Discussion
Checking file existance in Sharepoint with URL based on DAX?
Can anyone help me with the following? I'm building a report for an exported sales archive to consult old (Excel) data and lots of associated PDF files. The PDF files were automatically created a...
I created a workaround which gives me the required result. I created an extra column, which checks if an invoice number exists in the data:
Invoice_available = if(data[invoice]<>"","Yes","No")
Next I added an if-statement on the URL measure:
URL invoice = IF(data[Invoice_available]="Yes",
"https://tenant.sharepoint.com/sites/archive/documents/pdf/"&data[Year]&"/"&data[Ordernumber]&"-invoice-"&data[Invoicenumber]&".pdf"",
"")
This shows a URL icon if a match is found, otherwise it remains empty
Not 100%, but it gives the required result. 🙂
I created a workaround which gives me the required result. I created an extra column, which checks if an invoice number exists in the data:
Invoice_available = if(data[invoice]<>"","Yes","No")
Next I added an if-statement on the URL measure:
URL invoice = IF(data[Invoice_available]="Yes",
"https://tenant.sharepoint.com/sites/archive/documents/pdf/"&data[Year]&"/"&data[Ordernumber]&"-invoice-"&data[Invoicenumber]&".pdf"",
"")
This shows a URL icon if a match is found, otherwise it remains empty
Not 100%, but it gives the required result. 🙂
Next I added an if-statement on the URL measure:
URL invoice = IF(data[Invoice_available]="Yes",
"https://tenant.sharepoint.com/sites/archive/documents/pdf/"&data[Year]&"/"&data[Ordernumber]&"-invoice-"&data[Invoicenumber]&".pdf"",
"")
This shows a URL icon if a match is found, otherwise it remains empty
Not 100%, but it gives the required result. 🙂