Forum Discussion

Post Partisan

5 years ago

Solved

Show all the 'Word'

Dear Community, I would like to have a DAX that show all the Transaction Number and Job Number if JobInvoiceNumber is blank.

Need Help

Anonymous
5 years ago
Hi NickProp28 - Sorry, Not sure if i understood this correctly but if you want to just show the rows which have JobInvoiceNumber as blank, you dont need to write DAX.
It can be done using Filter on this Visual/Filter on this page pane.

Just select the InvoiceNo to blank and it will show you only 2 rows. Example as below:

Is this you are looking for?If not please explain further.

Cheers,
-Namish B

Anonymous

Not applicable

5 years ago

Hi NickProp28 -

Can you try this:

NewInvoiceNo = IF(SELECTEDVALUE('Table'[InvoiceNo]) = "", CONCATENATE(SELECTEDVALUE('Table'[TxnNumber]),SELECTEDVALUE('Table'[JobNumber])), SELECTEDVALUE('Table'[InvoiceNo]))

Hope this helps.

Cheers,

-Namish B

NickProp28
Post Partisan
5 years ago
Dear Anonymous ,

Thank you. But here is the expected outcome Im looking for.
Thats only show transactionNumber and JobNumber when the condition is blank in JobInvoiceNumber.
- Anonymous
  Not applicable
  5 years ago
  Hi NickProp28 - Sorry, Not sure if i understood this correctly but if you want to just show the rows which have JobInvoiceNumber as blank, you dont need to write DAX.
  It can be done using Filter on this Visual/Filter on this page pane.
  
  Just select the InvoiceNo to blank and it will show you only 2 rows. Example as below:
  
  Is this you are looking for?If not please explain further.
  
  Cheers,
  -Namish B