I have same multiple invoice id with different invoice amount.I want sum those invoice amount against one invoice.
Go to Solution.
You can create a calculated column and measure like below:
Best Regards,Qiuyun Yu
View solution in original post
@preetha_127 , Same solution as @v-qiuyu-msft , But in case you can have more than 3 digit
New Column =
var _len = search("(",[invoice] ,,0)
if(_len =0 ,[Invoice],left([Invoice],_len-1)
Proud to be a Super User!
I have multiple report,also i have summary of all the report.If i click one report in summary page ,it will navigate particular report.Help me..
Thanks & Regards,
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.