Forum Discussion
Unable to replace blank values cells
Hi, I am unable to replace the blank values with "NA". Here is the situation, there are some metric names that available in data source for the sept month but the values are empty, and for the ...
Anonymous , Create a seperate table for metric_name and join back it with you table and use mertic_name from the new tbale, Then this formula should work
New Table
mertic = distinct(mertic_name )
Also explore this option
amitchandak
Super User
Super UserAnonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi,
Unfortunately i am unable to attach the data source file or pbi file so attaching the screenshots of data source file and output
Snapshot 1 : datasource
Snapshot2 : Output
Replicated in excel file