Forum Discussion
netanel
Post Prodigy
Post ProdigyMatrix Table
Hey All! I have a number of issues with my matrix table and would love to help 1. I have a table with titles that I do not need, is there a way to delete the titles? (Or another idea to make it...
if its currency then try this one.
Net USD average per Day for Budget = VAR result = CALCULATE ( [Net USD average per Day], 'Revenues DB'[Data Source] IN { "Budget 2021" } ) RETURN FORMAT ( result, "$-#0.00" )If its still not works then is it possible for you to share your PBI file after removing sensitive data?
netanelPost Prodigy
Post ProdigyHi Samarth_18
1. Thanks
2. iam looking for change it based on certain conditions, but i dont no how
3.
can you help mr to put the dash "-"
her:
Net USD average per Day for Budget =
(CALCULATE(
[Net USD average per Day],
'Revenues DB'[Data Source] IN { "Budget 2021" }
))
Samarth_18
Community Champion
Community ChampionTry below code:-
Net USD average per Day for Budget =
VAR result =
CALCULATE (
[Net USD average per Day],
'Revenues DB'[Data Source] IN { "Budget 2021" }
)
RETURN
CONCATENATE ( "-", result )- netanel
Hi Samarth_18
i get this
I tried alone even before I asked and I can not replace the empty cell really weird
- Samarth_18
Try this one:-
Net USD average per Day for Budget = VAR result = CALCULATE ( [Net USD average per Day], 'Revenues DB'[Data Source] IN { "Budget 2021" } ) RETURN FORMAT ( result, "-0.00" )- netanel