Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

FORMAT - Switch and IF

Hi All,   I need to change my Switch calculation to remove the BLANK() Var = IF (     HASONEVALUE (Swap[Measure]),     SWITCH (         VALUES (Swap[Measure]),         "Sales",FORMAT('Sales'...
General Comment
Interesting Links
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You can use field parameters for both columns and measures.  

 

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

lbendlin Thanks. I have uploaded the sample data with the new columns in the link above

 

I want the same parameter 

 

But I want to have 3 columns as output in the visual

 

Year-MonthParaPara APara BPara C
     
     
     

 

How can I use the parameter to swap values for all the 3 columns? Thanks

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    looks like the link still has the old file. Please validate.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    lbendlin Thanks. I checked again and it has the new excel file.

    Please advise.