Forum Discussion
FORMAT - Switch and IF
Hi All,
I need to change my Switch calculation to remove the BLANK()
The scenario I am working on is similar to the below post :
https://community.fabric.microsoft.com/t5/Desktop/FORMAT-ignores-filter/td-p/1161371
Can you please help how to remove the null values but also take care of the formatting?
I just need to update the above calculation to remove the NULL values which show up when I use the FORMAT within the calculation. Thanks
13 Replies
- Something seems off with your formatting. Having not seen your sample data here is my guess.Var =IF (HASONEVALUE (Swap[Measure]),SWITCH (VALUES (Swap[Measure]),"Sales",FORMAT('Sales'[Number],"€#,##0.##"),FORMAT(SUM('Sales'[Qty]),"#,##")),FORMAT(SUM('Sales'[Qty],"#,##"))
lbendlin Thanks. The problem is not with formatting but with blanks. Please advise
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
lbendlin Can you please advise? Thanks
