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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

lbendlin Thank you, this works for one column. But I have 3 columns with different measures. How can I get the same parameter to swap on different fields? So ideally I would like one parameter.

 

Documents

 

Thanks

 

Please refer to updated data here

 

 

 

 

But 3 columns in all will have 6 measures to swap and for every column it will be Qty, Sls but different fields. Thanks

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.