I have to compare a list of invoice dates, from the "Related Invoices". The single "Start" date is entered in the dashboard filter controls. I have tried the following expression & a bazillion variations & I have only succeeded in getting random data output. So I am clearly not doing this right!
My dashboard filter controls that are working so far are in this expression:
AND(
IN([link_Venue],Carnz | Venues[Venue_ID]),
IF(ISBLANK(Index(Dashboard Reports[report_Supplier], 1)),FALSE,
IN([Supplier_Venue_Name],Dashboard Reports[report_Supplier])),
IF(ISBLANK(Index(Dashboard Reports[report_Venue], 1)),TRUE,
ISNOTBLANK(INTERSECT(SPLIT(Dashboard Reports[report_Venue],","),[Related Invoices][Venue_Name])))
)
However the minute I try to add the date filter I get weird output.
I have added these 2 expressions into the above expression BUT they are clearly not working for me. Any pointers or help is greatly appreciated.
IF(ISBLANK(Index(Dashboard Reports[report_Start_Date], 1)),FALSE,
ISNOTBLANK(INTERSECT(SPLIT(INDEX(Dashboard Reports[report_Start_Date],1),","),[Related Invoices][Invoice_Date]))),
IF(ISBLANK(Index(Dashboard Reports[report_End_Date], 1)),TRUE,
ISNOTBLANK(INTERSECT(SPLIT(INDEX(Dashboard Reports[report_End_Date],1),","),[Related Invoices][Invoice_Date])))
Thank you. Brad
LinkedIn
Twitter
