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 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.